I was ecstatic to find the advanced autofilter code on page 173 of this book (if you're in this forum and don't have the book, let me know and I'll post it.

I have not been able to figure out how to do one thing, though. I have an application that needs to search for a range of dates, e.g.., date > 1900 and date < 2000 (also for a range of currency values). My code runs through comboboxes on a form and transfers the values entered into a criteria spreadsheet. How would I get a date range into the spreadsheet so that the advanced filter code would work on it>

Thanks.

--elizabeth baker