Jump to Page 2 relatively...

Hi TW,

Try:

ActiveSheet.Next.Select


---
Regards,
Norman



"twaccess" <[email protected]> wrote in
message news:[email protected]...
>
> 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