Thread
:
Run-time error when copying entire row!
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ben McClave
external usenet poster
Posts: 173
Run-time error when copying entire row!
Hi,
Try this method. It worked for me.
With ActiveSheet.Range("LastRow")
.Offset(-1, 0).EntireRow.Copy
.Insert (xlDown)
Application.CutCopyMode = False
.Offset(-1, 0).Select
End With
-Ben
Reply With Quote
Ben McClave
View Public Profile
Find all posts by Ben McClave
Run-time error when copying entire row!