| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy loop | Excel Programming | |||
| Pretty easy If loop - help!! | Excel Worksheet Functions | |||
| How easy is it to loop in VBA based on cell contents? | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
Threaded Mode
