Is this possible?

B

Bardo

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?
 
D

Don Guillett

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 c>y then c.entirerow.delete
next
 
Top