I'm surprised you want to delete archived items, what happens if you have a query relating to one of these items?
Try this
It worked perfectly. Thank you royUK so much! I spent hours thinking about it, and you solved the problem in a few steps.
I actually will move these items to another archive sheet. The sheet I called "archive" is really just a summary.
Thanks again for your prompt response. As a beginner, I have learnt a lot about from this forum. All the best to you royUK and everyone!
Pleased to help.
Post back if you need further help.
Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.
Don’t have an account yet? Register yourself now and be a part of our community!
