Macro to go to A1 Cell
 

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

Macro to go to A1 Cell
 

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

--
Gary''s Student - gsnu200775


"Winnipeg Michael" wrote:

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

Macro to go to A1 Cell
 

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



"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200775


"Winnipeg Michael" wrote:

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

Macro to go to A1 Cell
 

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


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 11:21:01 -0700, Winnipeg Michael
wrote:

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