Next Sheet
 

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.

Next Sheet
 

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.

Next Sheet
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


Ren wrote:
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.

Next Sheet
 

range("A1").select



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