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

  • Thread starter Thread starter JDerm
  • Start date Start date
J

JDerm

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More Useful Row Autofit 1
How to autofit variable columns? 2
AutoFit Macro to Reduce row height? 0
Autofit rows where a cell contains results of formula 1
Macro: insert rows anywhere in the sheet 4
delete blank rows from other tab 5
autofit row code 7
How to make rows autofit when cells merge and multi line text inside 1

Back
Top