dates in macros
Hi
I have a problem with a filter in a macro. I recorded a macro and it gave
following code:
selection.autofilter field:=1, Criteria1:="13/12/07"
(This is date type dd/mm/yy by the way)
But when I change the criteria1 to "14/12/07" and run the macro it does not
filter correctly.
Is there something special I need to do with dates?
Thanks
Max
|