View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default shift the cursor down 2 rows please.

Hello from Steved

With the below macro how could I shift the cursor down 2 cells please.

Sub Broken()
Selection.EntireRow.Insert
ActiveCell.Offset(1, 0).EntireRow.Copy
Cells(ActiveCell.Row, 1).PasteSpecial
End Sub
Thankyou.