Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro command
How do I change this macro so that when activated, it moves to the cell below
instead of returning to the original cell? Sub Macro3() ' ' Macro3 Macro ' Macro recorded 11/10/2008 by Don ' ' Keyboard Shortcut: Ctrl+z ' ActiveCell.FormulaR1C1 = "" Range("H13").Select End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro command
Sub moveDown()
ActiveCell.Offset(1, 0).Activate End Sub "djungst" wrote: How do I change this macro so that when activated, it moves to the cell below instead of returning to the original cell? Sub Macro3() ' ' Macro3 Macro ' Macro recorded 11/10/2008 by Don ' ' Keyboard Shortcut: Ctrl+z ' ActiveCell.FormulaR1C1 = "" Range("H13").Select End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro command
Hi,
ActiveCell = "" remove the Select line. Side comment - using the shortcut key Ctrl+z is probably not the best choice, it will work but it overrides Excel's very useful shortcut key Undo = Ctrl+z -- Thanks, Shane Devenshire "djungst" wrote: How do I change this macro so that when activated, it moves to the cell below instead of returning to the original cell? Sub Macro3() ' ' Macro3 Macro ' Macro recorded 11/10/2008 by Don ' ' Keyboard Shortcut: Ctrl+z ' ActiveCell.FormulaR1C1 = "" Range("H13").Select End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro command
Hi again,
Let me amend my last, hasty email. ActiveCell = "" ActiveCell.Offset(1,0).Select -- Thanks, Shane Devenshire "djungst" wrote: How do I change this macro so that when activated, it moves to the cell below instead of returning to the original cell? Sub Macro3() ' ' Macro3 Macro ' Macro recorded 11/10/2008 by Don ' ' Keyboard Shortcut: Ctrl+z ' ActiveCell.FormulaR1C1 = "" Range("H13").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run a macro with the IF command | Excel Worksheet Functions | |||
If command in macro | New Users to Excel | |||
macro command | Excel Worksheet Functions | |||
Macro Command | Excel Discussion (Misc queries) | |||
macro command | Excel Discussion (Misc queries) |