View Single Post
 
Old 04-25-2014, 05:00 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default 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
Reply With Quote