Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cursor movement in a macro
This is really basic but I could not find a thread. I want to control the
movement of the cursor. Instead of moving up 7 cells, the macro records the cell it ends up in. How do I get the macro to just go up a specific number of cells. Thanks, Kanga |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cursor movement in a macro
Sub moveup()
Selection.Offset(-7, 0).Select End Sub -- Gary's Student "Kanga" wrote: This is really basic but I could not find a thread. I want to control the movement of the cursor. Instead of moving up 7 cells, the macro records the cell it ends up in. How do I get the macro to just go up a specific number of cells. Thanks, Kanga |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cursor movement in a macro
Thanks Gary, thats all I needed and my macro is complete.
"Gary''s Student" wrote: Sub moveup() Selection.Offset(-7, 0).Select End Sub -- Gary's Student "Kanga" wrote: This is really basic but I could not find a thread. I want to control the movement of the cursor. Instead of moving up 7 cells, the macro records the cell it ends up in. How do I get the macro to just go up a specific number of cells. Thanks, Kanga |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cursor movement in a macro
You are very welcome.
-- Gary's Student "Kanga" wrote: Thanks Gary, thats all I needed and my macro is complete. "Gary''s Student" wrote: Sub moveup() Selection.Offset(-7, 0).Select End Sub -- Gary's Student "Kanga" wrote: This is really basic but I could not find a thread. I want to control the movement of the cursor. Instead of moving up 7 cells, the macro records the cell it ends up in. How do I get the macro to just go up a specific number of cells. Thanks, Kanga |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |