Thread: Macro command
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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