Setting autofilter criteria

  • Thread starter Thread starter peterDavey
  • Start date Start date
P

peterDavey

G'day all,
I'm tryung to write some code that will set the value of criterion1 for a
date column in an Excel 97 table. When I recorded this action I got the
following code:

Selection.AutoFilter Field:=3, Criteria1:="01-Jun-04"

and it works OK. If I then run this macro it hides all rows. I suspect
that it might have something to do with date handling. Any suggestions will
be greatly appreciated.

cheers
peterDavey
Austin Health
Melbourne
 
Hi
not tested but try

Selection.AutoFilter Field:=3, Criteria1:= _
Dateserial(2004,6,1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter Criteria using named range 4
AutoFilter 3
AutoFilter Criteria in VBA 5
AutoFilter Criteria in VBA 13
AutoFilter Issue 2
AutoFilter Row Count 4
AutoFilter... not quite right 3
Macro for Autofiltering certain dates 1

Back
Top