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.


    Cheerio,

    vcoolio.

  • Hi M1,


    You can try this: