Hi

Please can someone help with this problem?

I have a column formated as a date (dd-mmm-yy).

i need to use autofilter to filter out cells in that column that contain
"Jul" using code.

At present it does not work as the cell.value is 24/07/09 and cell text is
24-Jul-09.
Can this be done?

I thought about converting the whole column into text format, but then the
cell reads "40018" instead of "24-Jul-09"

Sunil