Copy non-consecutive cells to clipboard

[ukyank]

Hi guys,

I've been searching for an answer and this is the closest I've gotten. I need a macro that will get the data in the last row of a column, copy that and copy other non-consecutive cells to the clipboard for pasting in a different application.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

[JasperD]

What's your question? This doesn't work?
Why not use a variant, put everything in there and just use split to paste?

[ukyank]

Sorry I missed out that last bit in my post. The above doesnt work. I keep getting a 400 error

Also the macro is called from a button on the sheet itself

[ukyank]

Darn thought this would be easier to search does nyone have any ideas where my code has gone wrong?

TIA

[jolivanes]

Have O4 and N4:R8. This would copy O4 twice. Is that what you want or an oversight?

[ukyank]

Ugh dumb mistake, I fixed that one but I still get the 400 error. The sheet was protected but I took off the protect and it still wont copy the cells.

[WHER]

"lngLast" evaluates to a rownumber, not a range.

[jolivanes]

Workaround code but I am looking forward to someone coming with a code to directly copy into clipboard. Still learning I am
It assumes that Column H is empty. If Not, change the reference to an empty column.

Please Login or Register  to view this content.