Autofilter on two Date Columns

OTPM · #1 04-25-2014, 05:00 AM

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

RudiS · #2 04-27-2014, 12:57 PM

I'm not sure if I understand correctly, but try something like this:

Code:

Sub FilterToday()
    With ActiveSheet.Range("A1").CurrentRegion
        .AutoFilter Field:=2, Criteria1:=xlFilterToday, Operator:=xlFilterDynamic
        .AutoFilter Field:=3, Criteria1:=xlFilterToday, Operator:=xlFilterDynamic
    End With
End Sub

OTPM · #3 04-29-2014, 12:42 AM

Hi Rudi
Not quite what I was after but thanks for the response anyway. I have now managed to resolve my issue.
Kind regards
Tony

RudiS · #4 04-29-2014, 12:56 AM

Great to know...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create statis Baseline date columns	Ross Jackson	Project	3	12-17-2015 04:00 PM
Trying to autofilter 8-10 rows of numbers to sort in a group	Jack-P-Winner	Excel	0	11-25-2013 10:55 PM
Sum on AutoFilter	Grasshopper	Excel	3	02-14-2013 01:41 AM
AutoFilter Criteria3	coxjamd	Excel Programming	2	01-17-2013 02:24 PM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM