to Copy the Entire Row

G

Guest

Hello from Steved

How would I modify please the below to copy an entire row Thankyou.

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

Don Guillett

Sub makerowvalues()
ActiveCell.EntireRow.Value = ActiveCell.EntireRow.Value
or
ActiveCell.offset(1).EntireRow.Value = ActiveCell.EntireRow.Value
End Sub
 
G

Guest

Sub Broken()
Selection.EntireRow.Insert
ActiveCell.Offset(1, 0).Entirerow.Copy
cells(ActiveCell.row,1).PasteSpecial
End Sub
 

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


Top