M
Mike R.
Hi -
This is driving me crazy. Can someone assist with this formula? It is
comparing the date on sheet "Pending List" to a static date on "Data" and if
it is less that the Data date, it will delete the row.
Thanks a bunch.
For iloop = irows To 2 Step -1
If Sheets("Pending List").Range("C" & iloop).Value <
Sheets("Data").Range("D19").Value Then Sheets("Pending List").Cells(iloop,
3).EntireRow.Delete
Next iloop
This is driving me crazy. Can someone assist with this formula? It is
comparing the date on sheet "Pending List" to a static date on "Data" and if
it is less that the Data date, it will delete the row.
Thanks a bunch.
For iloop = irows To 2 Step -1
If Sheets("Pending List").Range("C" & iloop).Value <
Sheets("Data").Range("D19").Value Then Sheets("Pending List").Cells(iloop,
3).EntireRow.Delete
Next iloop