Macro command

  • Thread starter Thread starter djungst
  • Start date Start date
D

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
 
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
 
Hi again,

Let me amend my last, hasty email.

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