VBA error copying and pasting to sheet

Here is the Code I have tried.

Please Login or Register  to view this content.

What is the error and when you click on Debug, what line of code is highlighted?

You may wish to change this line of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

The Range was the bug error. I copied you sugesstion and I get an error Highlight in Application.Union.Range("E3", "B7:B11", "E4", "B14:B17").Copy This is what pops up:

Compile error:

Wrong number of arguments or invalid property assignment

Please read the yellow banner at the top of this page on how to attach a file. This will allow us to work with your sample file to determine the issue.

Cannot determine issue. Asking for additional help.

Isn't the issue that you can't copy multiple ranges?

I think the problem is the shape of the total range you're trying to copy. You'll need to copy it in separate operations and paste to the relevant locations on the target sheet.