Autofilter on two Date Columns

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Autofilter on two Date Columns

FAQ

Thread Tools

Display Modes

04-27-2014, 12:57 PM

RudiS

Windows 8

Office 2013

Novice

Join Date: Mar 2014

Posts: 10

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:57 PM.