This method does work. But, is there a way to do this without losing the
formatting? I had colors, and made some columns smaller etc.. and there
disappeared whenI did the formula conversion by the above method.


Thanks


--
ShelbyMan
------------------------------------------------------------------------
ShelbyMan's Profile: http://www.excelforum.com/member.php...o&userid=26492
View this thread: http://www.excelforum.com/showthread...hreadid=393959