Sub test()
Dim i%, j%
With Sheets("2")
For i = .Cells.Find("*", , , , , xlPrevious).Row To 1 Step -1
If Application.CountA(.Rows(i)) = 0 Then
.Rows(i).Delete
End If
Next
End With
End Sub
Sub test()
Dim i%, j%
With Sheets("2")
For i = .Cells.Find("*", , , , , xlPrevious).Row To 1 Step -1
If Application.CountA(.Rows(i)) = 0 Then
.Rows(i).Delete
End If
Next
End With
End Sub