Macro command

[djungst]

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

 

[Mike]

Sub moveDown()
ActiveCell.Offset(1, 0).Activate
End Sub

 

[ShaneDevenshire]

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

 

[ShaneDevenshire]

Hi again,

Let me amend my last, hasty email.

ActiveCell = ""
ActiveCell.Offset(1,0).Select