View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike R. Mike R. is offline
external usenet poster
 
Posts: 59
Default Easy Loop question (with delete row)

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