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.
Invoking Plan Maker Formulae From Basic Maker
Re: Invoking Plan Maker Formulae From Basic Maker
Thanks for posting your problem. You can use Formula property of object range or cells in this case.
OR
You can refer to our user manual for complete details here.
Code: Select all
pm.Range("a2").formula="=DECIMALS(1.235)"
Code: Select all
pm.cells(2,1).formula="=DECIMALS(1.235)"