Hi,

In Autofilter, how to handle between the date format in cells and input
date format(for criteria)?
For example, date format in cells is d/m/yy but the input date format
is dd-mmm-yyyy.

Thx


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=512183

Hi Gabch,

Try something like:

Range("A1").AutoFilter Field:=1, _
Criteria1:="" & CLng(Range("E1").Value)

or

Range("A1").AutoFilter Field:=1, _
Criteria1:="" & CLng(DateValue("01/12/1944"))



---
Regards,
Norman



"gabch" wrote in
message ...

Hi,

In Autofilter, how to handle between the date format in cells and input
date format(for criteria)?
For example, date format in cells is d/m/yy but the input date format
is dd-mmm-yyyy.

Thx


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=512183