Try the technique I use:

Start recording a macro, manually do the piece that's missing (in this
case, record the steps you describe), stop recording and examine the
resulting code.

The recorded macro code should supply the answer you are seeking.

HTH!
Clif

wrote in message
...
rng.AutoFilter
rng.AutoFilter Field:=1, Criteria1:="=" & dtStart, Operator:=xlAnd, _
Criteria2:="<=" & dtEnd
.................................................. .................

Above code should filter some data but only places dates in custom
window and nothing else.
Having run the code I checked the custom window of column1 and I found
that the dates are respectively there and correct. Just press OK
button and bingo ! Desired result appears.
Am I missing something here to activate OK button ?
Thanks



--
Clif McIrvin

Change nomail.afraid.org to gmail.com to reply by email.
(nomail.afraid.org has been set up specifically for
use in usenet. Feel free to use it yourself.)