filter using today()
VBA
On Error Resume Next
Columns("H:H").AutoFilter
On Error GoTo 0
Columns("H:H").AutoFilter field:=1, Criteria1:=Format(Date,
Range("H2").NumberFormat)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"carly" wrote in message
...
i'd like to autofilter using today() but can't seem to remember the code
and
=today() does not work in the customization option. i know visual basic,
but
i'm unable to get it to work there either.
|