I have a range, D10:O12, D20:O22, and I would like to be able to cop
the range and paste it to another sheet in the same exact cells that
copied it from. So far, I've unioned the ranges together and I've trie
using .Copy method but that doesn't allow me to copy multiple ranges
Is there any way i can do this without having to write code t
explicitly state where each range goes? because in actuality, i hav
about 30 different ranges I need to perform this action on.

On a side note, i've noticed and been told that copying/pasting tw
different ranges from worksheet to another at the same time does no
preserve the spacing between the ranges in the first place. s
hopefully there's some way to do this in VBA without having to copy an
paste one range at a time

--
Message posted from http://www.ExcelForum.com