Macro to go to A1 Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Winnipeg Michael - 25 Mar 2008 19:21 GMT

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

Reply to this Message

Gary''s Student - 25 Mar 2008 19:24 GMT

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

Signature

Gary''s Student - gsnu200775

> I have done this before, but cant recall how its done.
>
[quoted text clipped - 4 lines]
> Thanks,
> Michael

Reply to this Message

Winnipeg Michael - 25 Mar 2008 19:40 GMT

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

> Sub routine()
> Range("A1").Select
[quoted text clipped - 8 lines]
> > Thanks,
> > Michael

Reply to this Message

Gord Dibben - 25 Mar 2008 20:34 GMT

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

Gord Dibben MS Excel MVP

>I have done this before, but cant recall how its done.
>
[quoted text clipped - 4 lines]
>Thanks,
>Michael

Reply to this Message