Use the macro recorder to write the code for a few operations. Then you
can edit the macro to complete all your data.
--
raypayette
------------------------------------------------------------------------
raypayette's Profile:
http://www.excelforum.com/member.php...o&userid=29569
View this thread:
http://www.excelforum.com/showthread...hreadid=563697