Copy/Paste Multiple times

[jomili]

I made a one time macro to copy a selected range and paste it multiple times under itself (see code). I'd like to make it more flexible for use in later situations. Right now the Last row looks only in Column A, and the paste begins in A. I'd like the last row to be the left column of my selection, and the paste to also be in that column. I'd appreciate any help in modifying my code.

Thanks.

Please Login or Register  to view this content.

[olle3770]

Hello Jomili,

I am not exactly sure what you are asking for, but maybe you can try this code

Please Login or Register  to view this content.

[jomili]

Olle,
What I'm looking for is code to copy my selected range, which may span multiple columns and rows, and paste it below the original data X-Number of times. For instance, if my selected range happens to be C5:M17 today, the first paste should be in C19:M31, and then many more times underneath. The orignal data may or may not be numeric, may or may not have formulas, and may or may not start in column A. My original code works, but only if the selected range begins in column A.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[jomili]

John,

Your code did the trick! Thanks for pointing me in the right direction!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.