I have tried to write code below to delete all items in Col M where ageing is less than or equal to 90
I have highlighted the rows to be deleted
When running the macro, no rows are being deleted
It would be appreciated if someone could assist me
Sub Delete_itemslessthan90()
Dim LR As Long, i As Long
Application.ScreenUpdating = False
Application.EnableEvents = False
For i = LR To 2 Step -1
With Sheets("Maturities")
LR = Cells(.Rows.Count, "A").End(xlUp).Row
If .Cells(i, 13).Value <= 90 Then
.Rows(i).EntireRow.Delete
End If
End With
Next i
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub
Bookmarks