Dim active sheet

  • Thread starter Thread starter Stanley Braverman
  • Start date Start date
S

Stanley Braverman

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

There's nothing to Dimension in this code, it will simply insert as many
cells as you have selected. What is/isn't it doing that you want it to?

Mike
 
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.
 
Back
Top