Thread: dates in macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Scott Max Scott is offline
external usenet poster
 
Posts: 4
Default 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