Paste Multiple Selections

smitpau

Board Regular
Joined
Apr 2, 2020
Messages
106
Office Version
365
Platform
Windows
Hi,

I'd like to be able to paste two ranges from another workbook (the data source) to a final workbook using with two macro buttons (one in each) one will say copy and the other paste (in the final workbook).

Copying seems to be okay as you can do something like the below or use a Union method. The issue seems to be that this combines it so removes the spacing between the ranges so when it comes to pasting it pastes in only one range.

Is there a way to copy multiple ranges but keep there independent integrity?
Appreciate I can use four macro buttons (one for each range per workbook) but it's not ideal.

Thanks

Range("f8:g9 i8:t9").Copy

Range("f78:g9, q78").Paste - Not possible
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

smitpau

Board Regular
Joined
Apr 2, 2020
Messages
106
Office Version
365
Platform
Windows
Thanks
Sort of, the spacing in the paste area would be different from the copy area
So for example C1,C2 would go to H1,H2 (instead of G1,G2)
 

shaowu459

Active Member
Joined
Apr 26, 2018
Messages
468
Office Version
365
Platform
Windows
Thanks
Sort of, the spacing in the paste area would be different from the copy area
So for example C1,C2 would go to H1,H2 (instead of G1,G2)
I see. Let's wait for an expert on Excel VBA.
 

smitpau

Board Regular
Joined
Apr 2, 2020
Messages
106
Office Version
365
Platform
Windows
Just to clarify I meant in the original post.

Range("f8:g9 i8:t9").Copy

Range("f7:g9, q8").Paste - Not possible
 

Watch MrExcel Video

Forum statistics

Threads
1,099,681
Messages
5,470,100
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top