Is this possible?

  • Thread starter Thread starter Bardo
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Copy Data from one worksheet to another 1
Excel Vba to change displayed year automatically. 14
For/Next Is Not Looping - Only Deletes First Instance 2
Wierd Formula Request 2
Delete Row when date in activecell doesn't meet the requierments 1
Delete rows based on date input 3
Date subtraction 1
Excel Is this possible?? 3

Back
Top