Next Sheet

R

Ren

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.
 
C

Chip Pearson

Ren,

Try something like

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


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

Frank Kabel

Hi
try adding the line
Application.Goto Reference:=activesheet.Range("a1"), Scroll:=True
 
Top