maybe this will work for you.

type this in the immediate window

?cells(Activewindow.Scrollrow,activewindow.ScrollC olumn).address

--


Gary Keramidas
Excel 2003


"AZSteve" wrote in message
...
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.