Copy / Paste Non-Contiguous Cells - User Selected

[Logit]

I have been unable to construct a macro for the following and looking for assistance :

The user will select a half dozen or so cells from the active worksheet.

The selected cells are in no particular range or order.

It is unknown which cells the user will select.

By holding down the CTRL key and clicking on the various cells - all desired the cells are selected.

The user 'copies' these cells then pastes that data to another location (not predetermined).

The location is a row and the data will display (for example): F20, F21, F22, F23, etc.


Your thoughts ?

[protonLeah]

I don't think you can copy a collection of disjointed cells using Ctrl,Copy. You would have to write a macro that gets the addresses of the selection, but it would have to stop to get the destination via an inputbox...

[Logit]

protonLeah:

Thank you for your response.

I'm not certain how to proceed with your suggestion. Your thoughts ?

Here is what I've been trying to work with (my original effort):

Please Login or Register  to view this content.

Please advise. This only pastes the last selected cell from copy.

I am ok with setting a designated location for the pasting. I can change the beginning cell later.

[protonLeah]

If you are selecting a single row from D:H then this might help:

Please Login or Register  to view this content.

[Logit]

Excellent ! Thank you so much !