I am having a hard time trying to picture what you are looking for.
Can you give a small example, say 5 rows by 5 columns of fake data so I
can see the before and after desired effect?
--
flydecoder
------------------------------------------------------------------------
flydecoder's Profile:
http://www.excelforum.com/member.php...o&userid=27288
View this thread:
http://www.excelforum.com/showthread...hreadid=468076