I can record the macro to delete and autofit a selected
row. How can I get the macro to search for blank rows?

I have already tried to use an IF Then statement but I
can't seem to get the right syntax for the boolean
expression. Help!