get the row and column of the currently selected cell?

Joined
Apr 30, 2012
Messages
1
Reaction score
0
I thought this would be relatively simple, but I can't find an answer. I inherited some msp code that is reformatting some tasks in a project. The macro runs when the project_activate method is called,
What is happening is, If a user opens multiple projects, chooses for example start date on task 5 and then toggles between the 2 projects, the focus is somehow being reset back to the first column of the first task on the projectn and the users want the focus to stay where they left it.

without rewriting these macros, I thought I could get the row and column coordinates of the active cell or selection, store it in a variable, then after the macro runs just put the focus back with selectTaskcell. but I cannot find a way to get the row/column of the active cell.

any help is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top