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