Thanks guys, yeah I knew I could do it using a new worksheet, but that'
clumsy. I'll use Norman's to swap values (all I had to do was chang
the word Range to the word Variant, so simple, thanks
--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile:
http://www.excelforum.com/member.php...fo&userid=2556
View this thread:
http://www.excelforum.com/showthread.php?threadid=39038