Macro to go to the top of the screen

Posted by Sarah on July 31, 2001 7:15 PM

I an writing a simple macro going to different named cells. Each time I go to a named cell, I want that cell to move to the top left hand corner of the screen - how do I write this???

Posted by Ivan F Moala on July 31, 2001 8:03 PM

Sub Goto_()
Application.Goto Range("MyNamedRange"), True
End Sub

Ivan

Posted by Sarah on August 09, 2001 9:54 PM

Thanks