H o l a:
Si quieres solamente borrar los datos de la columna A, utiliza la siguiente macro
Sub BuscarBorrar()
'Por.Dante Amor
Set b = ActiveSheet.Columns("A").Find("Order was shipped from the Coppell distribution center")
If Not b Is Nothing Then
If Cells(b.Row - 1, "A") = "" Then
Range("A" & b.Row).ClearContents
Else
Range("A" & b.Row & ":A" & Range("A" & b.Row).End(xlUp).Row).ClearContents
End If
End If
End Sub
Si quieres borrar el contenido de todas las filas:
Sub BuscarBorrar2()
'Por.Dante Amor
Set b = ActiveSheet.Columns("A").Find("Order was shipped from the Coppell distribution center")
If Not b Is Nothing Then
If Cells(b.Row - 1, "A") = "" Then
Range("A" & b.Row).EntireRow.ClearContents
Else
Range("A" & b.Row & ":A" & Range("A" & b.Row).End(xlUp).Row).EntireRow.ClearContents
End If
End If
End Sub
Si quieres eliminar las filas:
Sub BuscarBorrar3()
'Por.Dante Amor
Set b = ActiveSheet.Columns("A").Find("Order was shipped from the Coppell distribution center")
If Not b Is Nothing Then
If Cells(b.Row - 1, "A") = "" Then
Range("A" & b.Row).Delete
Else
Range("A" & b.Row & ":A" & Range("A" & b.Row).End(xlUp).Row).Delete
End If
End If
End Sub