Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to delete entire rows if the date of cells in rows ab, ac, ad
adn ar are before Dec 1, 2005. I can do a delete based on the contents of a single cell easily enough, but this throws me. For example: ab ac ad ae ------------------------------------------------ 12/2/05 | 11/5/05 | 11/3/05 | 11/30/05 11/30/05 | 11/1/05 | 11/5/05 | 11/5/05 I would like the routine to delete the second row, since all dates are before 12/1/05, but leave the first row intact since at least one date is after 12/1/05. Of course, the live spreadsheet includes more than just two rows. Any help would be greatly appceciated. Thanks -tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Help with ActiveCell.EntireRow.Delete | Excel Discussion (Misc queries) | |||
Need Help with ActiveCell.EntireRow.Delete | Excel Discussion (Misc queries) | |||
How to fix cell.entirerow.delete? | Excel Programming | |||
EntireRow.Delete | Excel Programming | |||
entirerow.delete multiple text conditions | Excel Programming |