Thanks Ron, it works great, but is there a way to continue the macro without
having to open the Custom autofilter box and click OK?
Grid

"Ron de Bruin" wrote:

Hi Grid

autofilter on "Today" using a macro/VBA code

Try this for column A

Columns("A").AutoFilter Field:=1, Criteria1:="=" & DateSerial(Year(Date), Month(Date), Day(Date))


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Grid" wrote in message ...
Using "CLng(Range("V1").Value)" in VBA I end up with 19/11/06 in the custom
box, when the actual date is 26/11. Field formatted dd/mm/yyyy. Just want to
autofilter on "Today" using a macro/VBA code. All ideas appreciated.
Grid