Take a look at:

http://www.mvps.org/dmcritchie/excel/swap.htm
--
Gary's Student


""jeremy via OfficeKB.com"" wrote:

If i have 2 cells (or groups of cells) is there a way to exchange the
contents or do I have to copy/paste the first contents into empty cell, then
copy/paste second contents into first cell, etc, etc....

Thanks.

Jeremy

--
Message posted via http://www.officekb.com