| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell to another cell using Macro | Excel Worksheet Functions | |||
| macro to move part of cell contents to another cell | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Macro for cell selection starting with Last Cell | Excel Worksheet Functions | |||
Linear Mode
