LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Jump to Page 2 relatively...


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Key to Jump to end of row Susan Excel Discussion (Misc queries) 2 August 4th 09 10:19 PM
jump jobra Excel Programming 3 August 22nd 05 09:15 AM
Excel should let hyperlink of PDF jump to a specific page like IE. Kenn Tan Excel Discussion (Misc queries) 2 April 18th 05 09:23 AM
When entering data into excel spreadsheet cell, the page just jump jodj Excel Discussion (Misc queries) 1 March 1st 05 05:51 PM
How to jump date? Akhilesh Dalia Excel Discussion (Misc queries) 4 February 15th 05 07:59 AM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"