shift the cursor down 2 rows please.

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Vba workout if a selection is part of a group? 0
Macro issue 4
to Copy the Entire Row 3
cursor goto a5 in Sheet1 but 1
Border Cells 4
Add one more criteria 2
Help with VBA to find data delete it change font, add lines then looptill end of file 4
Macro with sum function 1

Top