I have a list of 100 dates and would like to write a macro that allows you to type in 2 dates and click a button to filter all dates between the two I have input.
I hope that is clear enough .
Thanks in advance
Danny
I have a list of 100 dates and would like to write a macro that allows you to type in 2 dates and click a button to filter all dates between the two I have input.
I hope that is clear enough .
Thanks in advance
Danny
Hi, Danny ,
both the Autofilter as well as the Advanced Filter feature what you want (without the use of VBA) -why do you need a macro?
And if so: make all cells visible, get the last row, loop from start to end and compare if the date is greater or equal to cell-value Start and less that or equal cell-value end. If so, use something like
where lngCounter is the Row counter inside your loop.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks