You can use

Application.Goto Sheets("Sheet1").Range("A1"), True




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"geebee" (noSPAMs) wrote in message ...
hi,

I would like to know how to programatically go to the top of an excel
spreadsheet. Does anyone know the code? I tried Range(A1").Select, but that
doesnt work. For example, when the report is reopened, the top of the page
is not shown, even though the code says Range("A1").Select before I saved it.

Thanks in advance,
geebee