filter macro-Addendum
As an addendum,
Sheets(wks.Name).range("A8:F8").AutoFilter field:=1, Criteria1:=mv
mv = range("f3").End(xlDown).value
the field for this one is what's selecting the text filter, instead of the
list of elements that are normally selected. (I.e., once you set the filter,
you have a choice of options. Sort Alpha-forward/reverse, sort or filter by
Color, Clear filtered, text filter, and a list of field contents.)
I need the field contents option always in this routine.
It works fine when it's selecting a numeric value for my criteria. But when
I set my criteria as "Blanks" it jumps to the text filter.
Then, when I went to look at the text filter setting, it'd selected a name,
instead of a blank value-- as I would've anticipated. I.e., at the bottom of
the field contents, there's generally a "Blanks" selection if there are
blanks in your selection for filtering-- and in my specific case, there's
always a "Blanks" option in the field contents.
"SteveDB1" wrote:
morning all.
I have a macro that I obtained from Tom Hutchings last year, and it just
recently began selecting the text filter, instead of the drop down list
normally selected.
|