choosing cell to top left of visible window

  • Thread starter Thread starter AZSteve
  • Start date Start date
A

AZSteve

Excel 2003 and 2007 > Because displays vary, when I click a macro button to
go to a different part of the sheet, I want to choose a cell in column A so
that it appears at the upper left of the current window. I can't seem to get
it to work in
Excel 2003 - the selected cell appears some where in the middle.
 
maybe this will work for you.

type this in the immediate window

?cells(Activewindow.Scrollrow,activewindow.ScrollColumn).address
 
Try it this way...

Application.Goto Range("A100"), True

Just change the "A100" to the address of the cell you want to place in the
upper, left corner of the window.
 
i thought you wanted to identify the cell that is in the upper left corner
of the sheet.
 
Back
Top