Macro for duplicating cell range and horizontally concatenating x times

* New to VBA but experience with C, Matlab, and Python

I'm trying to create a macro that allows me to copy columns and then paste those selected columns x times to the right of the original selection.

e.g.

original columns: u v w x y z
columns to copy twice: x y z
new columns: u v w x y z x y z x y z

Challenges:

- Not all columns have the same number of rows (some are shorter than desired range and some are longer)
- Every third column is blank until row 61

Right now my macro looks like this:

Please Login or Register  to view this content.

So instead of inserting where my input range ends, it inserts at the first instance where there is no value in the 10th row (+1)...

Please help

Try e.g. in this way:

Please Login or Register  to view this content.