Excel Multiple Copy and Paste

[vaneagle]

I am trying to copy a various cells from a range and then paste then.
This code works fine.

Worksheet.Range("A77:A82,L77:N82").Select
Selection.Copy

Fairly easy except when some of the info is situated in a different row to that of the initial range which you are copying.

But if I want to copy at the same time say: E86:E92 excel won't let me paste it as it can't copy and paste multiple selections.

Does anyone know of a way around this??

 

[Loomah]

As far as I'm aware there is no work around for this. If it's something xl can't do then that's it really.

It would seem that you'll have to bite the bullet and copy the ranges separately.

If you need further help with, for instance, ensuring that all your data is pasted together, or what ever, post back!

Happy Friday
"I'm melting"
;-)

If a man says something and there are no women there to hear him, is he still wrong?