If you update the criteria with a macro.

A filter isn't like a formula. It has to be applied.

--
Regards,
Tom Ogilvy

"Acute Mind" wrote in message
...
Is there a way to do the autofilter without having to literally choose the
date each time? I mean, is there a way to set the autofilter to show rows
with today's date in a specific column all the time?