That one line isn't the culprit.

But there could be a few reasons...

1. Your worksheet is protected

2. Whatever you copied isn't in the clipboard at that moment.
if you add
msgbox application.cutcopymode
right before the .paste line, what do you see?

3. You're pasting into a range that can't be the same size:
Range("a:a").Copy
Range("b2").Select
ActiveSheet.Paste

(I'm guessing #2.)




Marc wrote:

We recently upgraded some PCs from Office 2000 to Office 2003, and now when
we run an Excel Macro that copies data, I am getting the following error.

Run time Error 1004 "Paste method of Worksheet class failed"

The code causing the exception error is "ActiveSheet.Paste". Is this command
no longer legal in Office 2003?? Is there some other VB command that should
be used other than "ActiveSheet.Paste" for 2003 or a security patch that is
needed?

--

Dave Peterson