Ren,

Try something like

Application.Goto Worksheets("Sheet2").Range("A1"), True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Ren" wrote in message
...
Hi to all

I'm trying to get to my next sheet and at the same time go to
the top of the sheet.

I have the following code:

' Go to Sheet2
Sheets("Sheet2").Select

This takes me to Sheet2, now how do I get to A1?

Thans for your help.