#### StephenArg

##### New Member

- Joined
- Mar 22, 2019

- Messages
- 4

I have a workbook with integers stored in 6 contiguous columns and 3 rows. ("source WB")

For example: A1:F3. However, this range changes from week to week, so the selection of the source range needs to be dynamic.

I have another workbook ("destination WB") where I want to paste special (values) the above data, but into non-contiguous columns, as the intermediate columns have a formula in them that I don't want to be overwritten:

For example:

G24 in destination WB: Paste data from A1 from source WB

H24 in destination WB: Ignore as contains a formula

I24 in destination WB: Paste data from B1 from source WB

J24 in destination WB: Ignore as contains a formula

K24 in destination WB: Paste data from C1 from source WB

etc, etc across the six columns A:F from source WB being pasted to columns G:Q in destination WB and the three rows 1:3 being pasted to rows 24:26.

Essentially, I'm looking for a way to split the range of data in the clipboard into up to 18 individual values (i.e. to create an array) that can then be pasted special into the destination WB, one value at a time. In fact, ideally, I would like to be able to select any number of columns from the source WB, from 2 to 6 and then have the VBA code use the number of columns to determine how to paste the result into the destination WB, but I can manage with a fixed column range. The number of rows will always be identical, i.e. three contiguous rows from the source WB will always paste to three contiguous rows in the destination WB.

I hope that my explanation is clear and would be grateful for any help you can give to solve this.