PasteSpecial Method of Range Class Failed

[mrbickelsworth]

Please help! I cannot understand why I might be getting the runtime 1004 error: PasteSpecial Method of Range Class Failed for the red highlighted line.

What I am trying to do:

When a user completely fills out the form they click a button to copy the information to another workbook. I want the copied information to be sorted in descending order, thus it inserts a blank row at the top, copies the first line of info, pastes the values to that blank first row, then repeats.

Please Login or Register  to view this content.

[AB33]

Do you have a sheet called "Record"?

Please Login or Register  to view this content.

[mrbickelsworth]

Do you have a sheet called "Record"?

Please Login or Register  to view this content.

Yes, it is Sheet1 of wbOpen

[mrbickelsworth]

Nevermind!!! I just realized the line should read

Please Login or Register  to view this content.

not "Operation"

[AB33]

I did not notice it, but I normally tend to remove named argument and that resolves the error.

[jaslake]

Nevermind...