Set ActiveCell in PlanMaker with script

Post Reply
Larsdddd
Posts: 4
Joined: Tue Oct 19, 2021 11:24 pm

Set ActiveCell in PlanMaker with script

Post by Larsdddd »

Hi
I've been playing around with scripts in PlanMaker and they are useful enough. But there's one thing I can't figure out. Is it possible to set the ActiveCell on a spreadsheet in a script?

I've found ActiveCell, which is supposed to be a pointer to the active cell. But is it possible to change the value (the cell adress) of ActiveCell?

Hope for help
Lars
Larsdddd
Posts: 4
Joined: Tue Oct 19, 2021 11:24 pm

Re: Set ActiveCell in PlanMaker with script

Post by Larsdddd »

Hi
I figured out how to achieve what I want with SendKeys. But it would still be great to be able to set ActiveCell by supplying a cell address.

Lars
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: Set ActiveCell in PlanMaker with script

Post by SuperTech »

If you want to activate any specific range or cell of the sheet, you can simply use Select method of the object Range or Cell. Please check the below examples:

Code: Select all

pm.Range("B2:F5").select
pm.Rows(2).Cells(5).select
Larsdddd
Posts: 4
Joined: Tue Oct 19, 2021 11:24 pm

Re: Set ActiveCell in PlanMaker with script

Post by Larsdddd »

Fantastic!
This is exactly what I need. I should have thought about that. :D

Thank you!
Lars
Post Reply

Return to “BasicMaker 2021 for Windows”