Delete blank rows and columns in Excel through macros

  • Hi Excel solvers. Please help me as I would like the macro to figure if there is any blank rows or columns and delete them. How could I write this in macro? Thank you.

  • Hello M1991,

    You had best attach a sample workbook showing us exactly what you are trying to do. Please give us a precise description.



  • Hi M1,

    You can try this: