Hi ,

I'm trying to remove all blank rows within my sheet and have the following code but it says it can't be done when overlapping different sections?

    With Sheets("Other Assets Load Template")
    .Range("A2:Y" & lastrow).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    End With