Set ActiveCell in PlanMaker with script

[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]

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]

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]

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

Thank you!
Lars