autofilter dates

[ProteanBeing]

I want to activate an existing autofilter to sort between two dates. The dates are stored in two cells (lets call them A1 and A2 for this example). I've tried several syntax versions but nothing seems to work. Please help.

[Bob Phillips]

Dates are problemmatical in VBA. The best way that I have foudn is to use the numberformat of the first cell in the range being filtered, like this



rng.Autofilter Field:=1,Criteria1:= Format(Date, rng.Cells(2,1).Numberformat)

[ProteanBeing]

thx