Code works but gives error message

Can someone please tell me why this code works, but gives an error 1004 message "Copy method of Range class failed"? Debug highlights the penultimate line.

I have been searching for days and changed the offending code from "select" to what seems to be accepted as more efficient, but with the same result.

Any help appreciated.

Please Login or Register  to view this content.

The destination is not fully qualified. Which workbook are you pasting to? Specify workbook, worksheet and range, just like you did in the first part of the statement.

In general, I'd use dim statements at the beginning of the code to define source and target workbooks and worksheets, then set them to the required workbooks and sheets. Then the code will be so much easier to write (and read).

Thanks for your reply. The first part of your answer didn't work , so I'm working my way through part 2 and will post back here when I either work it out or give up. Hopefully this afternoon.

Steve

It appears that the multiple groups of columns to be copied is the cause of the problem. Even with Dim statements, until I copied each group of Columns separately, I was getting the error message - despite it actually doing what I wanted.

Anyway, thanks teylyn for your help. If you (or anybody?) can show me how to copy all the columns in one step, I'd appreciate it, but the code works as it is, so I'm happy. Will close the thread tomorrow if no replies.

Please Login or Register  to view this content.