I have a workbook + -37000 rows of Data (Cols A:W)
I have the following macro , but it runs for a long time and seems to be going into a loop so I closed it down through the task manager
I want to delete all rows where there is zero value in both Col T & U (for eg if T2 is zero and U2 is zero the row must be deleted)
I have the following macro , but it runs for a long time and seems to be going into a loop so I closed it down through the task manager
I want to delete all rows where there is zero value in both Col T & U (for eg if T2 is zero and U2 is zero the row must be deleted)
Code:
Sub Delete_Zeroes()
Sheets("Sheet1").Select
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To lr
If Range("T" & i).Value = 0 And Range("U" & i).Value = 0 Then
Range("T" & i).EntireRow.Delete
End If
Next i
End Sub