Workbook macro telling me doesn't work on multiple selections

[gareth7412]

Hi

I have this macro but it tells me that it dont work on mutliple selections. How can I get round that?

[6StringJazzer]

You can't do that manually on a worksheet, either. You cannot copy non-contiguous cells from both multiple rows and multiple columns. I'm not talking about the Paste--you cannot even do the Copy.

You are copying many non-contiguous cells to a single target cell. What kind of result do you want to get? You will have to rewrite this to do one copy for the column C cells and another copy one for the column E cells.

One option:

Please Login or Register  to view this content.

This will give all values contiguously in a single column starting at Cells(lngEmptyRow, lngEmptyCol).

[jolivanes]

Or something like this maybe?

Please Login or Register  to view this content.

[jolivanes]

What is this giving you?

Please Login or Register  to view this content.

Your "lngEmptyRow" and "lngEmptyColumn" has me stumped (easy to do)
Where do you want to paste the result?

[jolivanes]

Taking a wild stab at it. Don't know if the lc and lr are right.
Try it on a copy of your original.

Please Login or Register  to view this content.

[gareth7412]

comes up with type mismatch here

ReDim Preserve celArr(1 To UBound(celArr), 1 To 2)

[6StringJazzer]

Did you try the solution in post #2?

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)