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?


    Code
    Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

    Re: Delete Empty Rows


    Code
    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!

Register Yourself Login