Macro Help

[Amy Beryl]

Hi All -

I am trying to write a macro (see below) that copies a 2 row range to another place. The "copy to" place is where the cursor is when I activate the macro. I want the macro to paste the row range to wherever I am when I run it. It's not working (if it was working I wouldn't be here). It seems that the cursor moves during the execution of the macro instead on staying where I am when I start the macro.

Any help would be appreciated.

Amy

Sub Macro2()
'
Rows("21:22").Select
Selection.Copy
ActiveCell.Select
Selection.Insert Shift:=xlDown
End Sub

 

[jmthompson]

Sub Macro2()
Rows("21:22").Copy
ActiveCell.Select
Selection.Insert Shift:=xlDown
End Sub

 

[VoG]

Maybe

Sub Macro2()
'
Rows("21:22").Copy
ActiveCell.Resize(2).EntireRow.Insert Shift:=xlDown
End Sub

 

[Amy Beryl]

You guys rock!