Good morning FarGardner

The excel rule is "you cannot copy non-adjacent ranges."
But you can. Sort of. If the selection to be copied includes the same
cells from a number of rows (eg. A1:A4 and C1:C4), or the same cells
from a number of columns (eg. A1:C1 and A4:C4), then it will work – but
with two peculiar side effects : any formulae copied will be pasted as
values, and any spaces included in the selection will disappear.

John Walkenbach provides a routine here that will copy multiple
ranges:

http://j-walk.com/ss/excel/tips/tip36.htm

Alternatively, I have a free add-in available to anyone who e-mails me
that will, amongst other things, copy and paste multiple ranges. If
you want this, please e-mail me at .

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=391517