View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger B. Roger B. is offline
external usenet poster
 
Posts: 24
Default Positioning on a sheet

I want to get a macro that will position a particular part of a sheet to
show on my screen when it is opened up no matter where the sheet is when
opened. In the past I have used the following which don't appear to work in
Excel 2002:

Range("CurrDay ").Select

Application.Goto Reference:=Range("CurrDay")



Any suggestions would be greatly appreciated.



Roger