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
|