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...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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