Setting autofilter criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: peterDavey (peter.davey_at_austin.org.au)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 18:11:00 +1000

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

Relevant Pages