Next Sheet

[Guest]

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.

 

[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

 

[Frank Kabel]

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

 

[eric lecocq]

range("A1").select