Error 32809 with ActiveSheet.Paste in Excel 1997

I have a spreadsheet with several macros I wrote in Excel 2003, and use several times per day. I recently tried to use the spreadsheet in Excel 1997, and one of the macros fails, although I cannot tell why. Maybe one of you gurus can help me?

I am simply copying a row, moving up one row, and pasting it. My code is as follows:

Please Login or Register  to view this content.

I went so far as to record a macro of the above steps in Excel 1997, and the recorder reproduces the code exactly. When I execute the recorded code, I get the same error as with my original macro:

Run-time error '32809'
Application-defined or object-defined error

When I debug, the ActiveSheet.Paste line is highlighted.

Any suggestions?

---GJCase

"lastrow" is a range, first several columns of a row. However, substituting Range("lastrow") Reference:="lastrow" gives me exactly the same error.

---GJCase