Dynamic Starting Row To Deleting Empty Rows

  • I saw this macro posted by Fengore back in 2006, and it works beautifully. Now my question: Is there a way to continue using that string but have it start from a certain row?

  • Re: Delete Empty Rows

    r = 12 'the first row that can be deleted
    Range(Cells(r, 1), Cells(Rows.Count, 1)).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!