pastespecial method of range class failed 1004

[Abbadon486]

Please help i cant explain how one workbook i have works perfectly with the below code and the other one which looks exactly the same has the "pastespecial method of range class failed 1004" error. Same code however bugs. I have checked the code line for line and on both and they match to the letter adn punctuation etc.

Any suggestions?

Please Login or Register  to view this content.

[Norie]

Does this need to be in 3 separate subs?

I think if it was all in one sub and was tidied up a bit you might avoid the error.

[Richard Buttrey]

Hi,

Do you have 'Option Explicit' before the first procedure?

Is the sheet to which you're pasting protected, and / or does it have any merged cells.

Have you tried exporting the module from the workbook that works and importing it to the workbook that doesn't?

[Norie]

This is how the code would look in one sub.

Please Login or Register  to view this content.

[Abbadon486]

Thank you for all the advice. The problem i had with "Option Explicit" is that when i typed it, it refused to go onto the line above the Sub name. How do you add this line without it flagging error?

[Richard Buttrey]

Hi,

On the face of it there's no reason why it won't be accepted. Is it at the very top of the module before any procedure?

What error message are you getting?

[Norie]

Option Explicit will not cause errors.

What it will do is force you to declare all variables which will actually help prevent errors.

The code I posted will compile and run.