Tom Ogilvy wrote:
acw gave you a good fix for the first part.

for the second part you can do

columns(2).SpecialCells(xlblanks).Entirerow.Delete

--
Regards,
Tom Ogilvy

geebers...that's about as efficient as I will ev4r get it...

Tony, Tom, thank you kindly

--
Message posted from http://www.ExcelForum.com