Te paso las 2 macros:
Sub EliminaFilas()
'Por Dante Amor
'
'eliminar toda la fila
'Asume que en la fila 1 están los encabezados
Dim lr As Long
With ActiveSheet
If .AutoFilterMode Then ActiveSheet.AutoFilterMode = False
lr = .Range("U" & Rows.Count).End(3).Row
.Range("A1:U" & lr).AutoFilter Columns("U").Column, "0"
.AutoFilter.Range.Offset(1).EntireRow.Delete
.ShowAllData
End With
End Sub
Sub EliminaCeldas()
'Por Dante Amor
'
'eliminar las celdas de la A a la T
'Asume que en la fila 1 están los encabezados
Dim lr As Long, i As Long
Dim a As Variant
Dim r As Range
'
Application.ScreenUpdating = False
If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
lr = Range("A" & Rows.Count).End(xlUp).Row
Set r = Range("A" & lr + 1).Resize(1, 20)
a = Range("A1:U" & lr)
For i = 2 To UBound(a)
If a(i, 21) = 0 Then Set r = Union(r, Range("A" & i).Resize(1, 20))
Next i
r.Delete Shift:=xlUp
Application.ScreenUpdating = True
End Sub