Error message whne copying alternative cells ranges

[vito01]

Hi All,


I am trying to copy and paste cells ranges from one workbook to another. When just selecting 2 ragnes, and therfore two destinations, it seems to be working but as soon as I select 3 ranges I am getting the error message attached

Any help woukd be great

Thanks
V

[sintek]

Not sure whether both workbooks are open or which is actual active, but play around with this concept...multiple noncontiguous copy paste...

Please Login or Register  to view this content.

[vito01]

Hi,

Thanks for coming back to me

Yeah, you are right, did not elaborate my point. Basically I am trying to copy some cells ranges from the file attached (excel soler, I duess this not the activa but just select) into a workbook, workbook1 (the active (?)) for example. the destinations is not contiguous

Does this makes sense?

Thanks a million again and any additonal help would be greatly appreaciated

Vito01

[sintek]

So...this I assume is the macro file...what is the name of the other file it must be copied to...

The code supplied in post 2 solves your problem...just need to change the red part to the name of the workbook(which is open) which is to be copied to...

Please Login or Register  to view this content.

[vito01]

Hey, for example, it can just be called workbook1

[sintek]

Like I said...change red part and code in post 2 solves...

[vito01]

Thank you!

[vito01]

Hi, me again. And if I wanted to apply pastespecialvalue or formattting?

[sintek]

Please Login or Register  to view this content.

TO

Please Login or Register  to view this content.

[vito01]

Thank you and have a great day!!

[sintek]

iF THIS WORKS, THEN PLEASE MARK THREAD AS SOLVED...tX FOR REP ADDED