Macro to look for blank rows in sheet, delete the row and autofit
 

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!

Macro to look for blank rows in sheet, delete the row and autofit
 

Hi
see
http://www.cpearson.com/excel/deleti...eleteBlankRows

--
Regards
Frank Kabel
Frankfurt, Germany


JDerm wrote:
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!