Dim active sheet
Sometimes I need to move cells down only several cells and at other times I
might need to move them down 30 or more cells. That's why I need individual
control of move cells.
"Bob Phillips" wrote in message
...
Why not just do
Cells.ClearContents
--
__________________________________
HTH
Bob
"Stanley Braverman" wrote in message
...
Can I add a DIM line for this macro?
It seems I need to access the complete sheet. If I have to many cells it
will not work correctly. With fewer cells it works fine
Sub Cell_Down()
'
' Cell_Down Macro
' Macro recorded 2/25/2009 by Windows User
'
' Keyboard Shortcut: Ctrl+d
'
Selection.Insert Shift:=xlDown
End Sub
|