Use the Macro Recorder to get the basics, then amend to suit.Hi, i want to filter column having date format in "dd-mmm-yy"
Column range :=E1 and autofilter field:=5
Its formatted numberCode does not work? What happens?
What is actually in the cell? Text or a formatted number?
yesAre you talking about Excel VBA?
Criteria1 is fine but still filter is not working, in column blank is there but what i want date value to be filtered.Misspelling: Citeria1 should be Criteria1. Code works. Don't even need Format() function.
There is an Excel forum here? The question belongs there if that's what the issue is about, but it's not uncommon to post things in the wrong place, no?Why are you posting a question about Excel VBA on an ACCESS forum?
Ok thanks it was not known to meWhy are you posting a question about Excel VBA on an ACCESS forum?
All VBA is not created equal!
You should probably try a forum dedicated to MS Excel.
Linq ;0)>