Hi All,
Really simple question here. I'm trying to delete a row if the value in the Column 62 is 0.
Here's what I have so far:
It runs ok and deletes the row but doesn't seem to recognise when the value in column 62 (BJ) is equal to 1.![]()
Sub findlast300() Dim row As Integer row = 3 For i = 1 To 9000 If Cells(row, 62) = 0 Then Rows(row).Select Selection.Delete Shift:=x1Up Else: row = row + 1 End If i = i + 1 Next End Sub
can anyone help?
Thanks
Bookmarks