Hello Team,
I am working on a little project and trying to copy a range, x amount of times. This is what I have:
So "LastColumn" is the number of times I want to copy the range.
The range can vary all the time so I just made it automatically with xlToRight. However for example I have the following:
G7 |
H7 |
I7 |
E2VA17 |
E2VA16 |
E2VA14 |
and the code just does this:
E2VA17
E2VA17
E2VA17
E2VA16
E2VA16
E2VA16
E2VA14
E2VA14
E2VA14
Its kinds good however I need it pasted it like this(lets say that LastColumn = 3, it should copy the range 3 times):
E2VA17
E2VA16
E2VA14
E2VA17
E2VA16
E2VA14
E2VA17
E2VA16
E2VA14
I really would appreciate any kind of help.
Regards,
Luis V.
Bookmarks