SoftMaker.com

I was finally able to make the code shown above work. But scope turned out to be tricky.
I had to find the right place to put:
Set pm = CreateObject("PlanMaker.Application")

I know how to define named ranges in PlanMaker but I would like to do it within Basic Maker.
Something like:
Dim ChrSet As Object
Set ChrSet = pm.Range("C9:K9")

I haven't been able to make anything like this work.

Nearly 3 years later I still have the same problem.

Is there any way in BasicMaker for PlanMaker to simulate the "ReSize" capability in Excel VBA?

Thanx

I wish there was a way to add additional cells to a named range in PlanMaker via BasicMaker.

Perhaps something like "Blk1.Columns.Add(5)" would add 5 more columns to the right of the named range "Blk1".

Thanks.

How do I invoke formulae from Plan Maker in Basic Maker code?
For example, "=DECIMALS(1.235)" in a cell of Plan Maker yields 0.235.
But n =DECIMALS(1.235) in Basic Maker results in "Sub or function not defined: DECIMALS"

Thanks.

Thanks. I just found it. Don't know how I missed it before in spite of several searches.

How can I set the Horizontal Alignment of a Range in Plan Maker with Basic Maker code? I'm guessing something like:

pm.Range("B2:F5").HorizontalAlignment = Centered

But I can't find an answer in the manual.
Thanks.

Is there a function to generate a random number?

I suspect the answer is that the Criterion can't use a cell reference. Correct?

In the "Income" col of the IRS tax table, "Table1", I want to find the largest value that doesn't exceed the value in cell G17. This works: =MAXIFS(Table1[Income],Table1[Income],"<147492") This doesn't: =MAXIFS(Table1[Income],Table1[Income],"<G17") Cell G17 is...

I have the professional versions 2016, 2018 & 2021 all installed on my Windows 10 machine. Can I remove the 2016 & 2018 versions without impacting the 2021 version?