ActiveSheet.Paste failing(Runtime error '1004')

[sanjeevap]

ActiveSheet.Paste is failing in Excel vetrsion 2010. I'm getting the following error.
Runtime error '1004'
paste method of worksheet class failed

But when I run in debug mode ActiveSheet.Paste works.

The macro reads a selected pdf file and writes to a excel sheet. Below is the code .

Any ideas why ActiveSheet.Paste is failing in the code below. The same code works in Excel 2002


_____________________________________________________________________________________________________________

Please Login or Register  to view this content.

[Alf]

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

[Norie]

Are you sure something is being copied?