Hi TW,

Try:

ActiveSheet.Next.Select


---
Regards,
Norman



"twaccess" wrote in
message ...

I have a good macro that works very well for me. At the end of the
macro, I want to be able to go to A2 on the second page.

Previously, I used the name of the page "Projmon" that was created to
be able to do this. But, the inputting report that I'm recieving now is
coming in with different names, so this doesn't work anymore.

Columns("A:D").Select
Columns("A:D").EntireColumn.AutoFit
Sheets("projmon").Select
Range("A2").Select
End Sub

Is there a way of changing this script so thaat it says at the end of
the programme, go to A2 on the second page ?


--
twaccess


------------------------------------------------------------------------
twaccess's Profile:
http://www.excelforum.com/member.php...fo&userid=2192
View this thread: http://www.excelforum.com/showthread...hreadid=561480