Solved: Why am I getting an error?

[Opv]

What is causing an "Object Required" error on the second line of this code? Interestingly, the copy/paste actually occurs as desired, the error notwithstanding.

[VBA]
Range("A17").EntireRow.Copy
Range("A15").EntireRow.Insert(Shift:=xlDown).Paste

[/VBA]

[mikerickson]

Insert is a method that doesn't return an object. Hence the "Object requried" (for the .Paste method) error. Try

[vba]Range("A15").EntireRow.Insert Shift:=xlDown, CopyOrigin:=True[/vba]

[Opv]

Insert is a method that doesn't return an object. Hence the "Object requried" (for the .Paste method) error. Try

[vba]Range("A15").EntireRow.Insert Shift:=xlDown, CopyOrigin:=True[/vba]

Now I'm getting a "Named Argument not found" with respect to the "CopyOrigin". Does the recommended procedure only work on newer versions of Excel? I should have stated at the outset that I'm running Outlook 2000.

[chamdan]

Use this instead.
[vba]
Range("A15").Select
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False
[/vba]
Chuck

[Opv]

Thanks, chamdan. I was hoping to avoid having to use "Select." I think I have figured out how to make mikerickson's suggestion work.

[Opv]

Thanks, by the way, to mikerickson. I appreciate the help.