Select the range, press F5, special and select blanks, press Ctrl and minus
(dash), select entire row

--

Regards,

Peo Sjoblom


"Batman" wrote in message
...
How do I delete rows that contain blank cells in an Excel Worksheet?