I have a macro using For & Next. The code works if the code is run multiple times. I would like the code to complete the process by pressing the macro button once.
Can someone look at the code and make the necessary changes PLEASE.
This macro deletes all dates in column "B" if less than column "F" less another 5 days.
Dim x As Long
Dim LastRow As Integer
LastRow = ActiveSheet.Cells(Rows.Cou
For x = 3 To LastRow
Debug.Print Cells(x, "B").Value
If CDate(Cells(x, "B")) < CDate(Cells(x, "F") - Day(5)) Then