Thread: filter macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveDB1 SteveDB1 is offline
external usenet poster
 
Posts: 414
Default 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.