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.
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"
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?