Macro to go to A1 Cell

[Winnipeg Michael]

I have done this before, but cant recall how its done.

I want to create a button with a macro on it, so when I hit the button, the
highlighted cell will be the A1 Cell. I know I need to create the macro
first; thats the problem I am having right now.

Thanks,
Michael

 

[Gary''s Student]

Sub routine()
Range("A1").Select
End Sub

 

[Winnipeg Michael]

Hey Gary"s Student, thanks.
I knew it was an easy one, just wasnt getting it correct.
I better keep this post for future reference.

Thanks again,
Michael

 

[Gord Dibben]

CTRL + Home will take you to A1 if there are no frozen panes.


Gord Dibben MS Excel MVP