View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
twaccess[_24_] twaccess[_24_] is offline
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