if you sort by any column all the blanks will be together & you can
delete them all.
then resort back to your original order, if needed.


--
carstowal
------------------------------------------------------------------------
carstowal's Profile: http://www.excelforum.com/member.php...o&userid=37476
View this thread: http://www.excelforum.com/showthread...hreadid=571515