Help controling cell selection navigation with macros!
Posted by Frank H. on March 10, 2001 8:25 AM
I use a lot of control buttions to take the user to another area of the worksheet or to another tab in the workbook to input information. In all instances, I want to have the screen display the new area specifically and place the active cell as directed.
However, I cannot seem to get it correct in the macro.
I have "recorded" macros that still do not work correctly when executed.
Example: Sheets("Projected Hours Profile").Select
ActiveWindow.LargeScroll Down = 1
This is an attempt to have A17 as the top left cell visible on the screen and the cursor placed on C28 for data entry.
My results are A1 at the top left & the cursor on C28.
I frequently have this problem and have not been able to find a solution.
What am I doing wrong?