I have a good macro that works very well for me. At the end of th
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 t
be able to do this. But, the inputting report that I'm recieving now i
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 o
the programme, go to A2 on the second page

--
twacces

-----------------------------------------------------------------------
twaccess's Profile: http://www.excelforum.com/member.php...nfo&userid=219
View this thread: http://www.excelforum.com/showthread.php?threadid=56148

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

Sheets(2).Select
Range("A2").Select

HTH

Die_Another_Day
twaccess wrote:
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

Thanks Alan and 'DAD', I'll give these a try tomorrow when I get into
work.

I'm late in my reply because I've been away all weekend.

Thanks


--
twaccess


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