Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Delete all rows between two certain dates when asked? If the user was asked
what dates, they entered 4/1990 to 5/2001, it would delete all row that did not meet this criteria? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try using an input box to ask for the start date another input box to ask
for the stop date a for/each macro to delete the rows. Untested x=inputbox("start date?") y=inputbox("stop date?") for each c in selection if c<x and cy then c.entirerow.delete next -- Don Guillett SalesAid Software "Bardo" wrote in message ... Delete all rows between two certain dates when asked? If the user was asked what dates, they entered 4/1990 to 5/2001, it would delete all row that did not meet this criteria? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|