Hi theres plenty of stuff here for removing blanks that you should be
able to modify, its all self explanatary with worked examples.
http://www.mvps.org/dmcritchie/excel/delempty.htm

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=557882