to Copy the Entire Row

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Sub makerowvalues()
ActiveCell.EntireRow.Value = ActiveCell.EntireRow.Value
or
ActiveCell.offset(1).EntireRow.Value = ActiveCell.EntireRow.Value
End Sub
 
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

Run-time error when copying entire row! 5
Macro issue 4
Loop Repeats - PLS HELP 2
Returning to first offset point. 4
Issues with UserForm Box 5
Start on select cell 2
Alpha Numeric’s bunch together 1
Still retuns to begining of range, Please Help 4

Back
Top