Trying to do a copy macro

[b_rianv]

Good morning everyone,

I am trying to do a copy macro which will copy a row" that has a selected range" in that row in a worksheet and paste it in a different row "that has a selected range also" within the same worksheet. I am trying to do a message popup that will ask me "what" row I would like to copy, so I would say something like "Row A18,range C18:H18" then another message popup would ask "where to paste", so I would say something like "Row M2, range O2:T2, ALL rows where copied from and pasted to are dynamic "always changing" and the macro would execute.What the macro will be copying is alpha/numeric values.
The macro would run when I click a button I have linked it to in the worksheet. Also this macro would not have to delete anything as I have already a macro that does this.


Is this even possible and any help would be great.

Thank you,

[JBeaucaire]

This would do that:

Please Login or Register  to view this content.

[b_rianv]

It kinda works, the range copied from will not always be the same and the range pasted to will not always be the same within the same sheet... I need to be able to tell the macro what range to copy as the range will be different each time I need to copy..

[b_rianv]

I got it to work. Now is there anyway to only copy the data and not the formatting (color of cell)?

[JBeaucaire]

Please Login or Register  to view this content.

[b_rianv]

You are the MAN!!! Thanks!!!!