Excel: select cell without scrolling
What Vba would I use to select a cell on a worksheet without scrolling the screen
E.g., I have the following code: activesheet.cells(1,1).sel
E.g., I have the following code: activesheet.cells(1,1).sel
wshark83
activesheet.range("A1").se
ASKER
Thank you whark, nonetheless If I move to row 10000 and run that code in the immediate window, the screen will skip to the top. I would like my screen to stay focused on row 10000 even though code selected cell "a1".
You almost certainly don't need to select the cell and then you won't have the problem. What are you trying to do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ssaqibh - very neat.