Thank you both, they work great!

Regards
Robert

"Robert Lowe" wrote in message
.. .
Hello,

I there an easy way to delete all rows if a certain colum is blank?
I have 5000 rows and wish to delete all, f colum b is blank.

Thank you