Autofilter on two Date Columns
Hi Folks
I am having trouble using VBA to Autofilter on two date columns using VBA. I have searched and failed miserably :-(.
Basically I have two columns, one called "Proximity Date" and one called "Elimination Date". What I want is to Autofilter my list where todays date falls between those two columns.
Any held/advice appreciated.
Thanks in advance.
Tony
|