Thread: [Solved] Macro trouble
View Single Post
 
Old 10-02-2010, 12:40 AM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
try this. Works for me.

Note: the second last row: "ActiveCell.Offset(-1, 0).Rows("1:1").EntireRow.Select" is only to get the moved row marked.

Kind regards
Bjorn


Sub MoveDown()
'
' MoveDown Macro
'
' Keyboard Shortcut: Ctrl+a
'
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Cut
ActiveCell.Offset(2, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown
ActiveCell.Offset(-1, 0).Rows("1:1").EntireRow.Select
End Sub
Reply With Quote