Use column header instead of field number to autofilter

[Chewyhairball]

Hi Guys

Is there a way to auto filter a table using a column header name instead of a field value

eg. Selection.AutoFilter Field:=15, Criteria1:="=*" & strUserIn & "*", Operator:=xlAnd

Instead of using 15 use the name of the header there. The table is called "table2" and the header is called "type".

thanks

Rory

 

[Fluff]

How about like

   With ActiveSheet.ListObjects("Table2")
      .Range.AutoFilter .ListColumns("Type").Index, "=*" & strUserIn & "*"
   End With

 

[Chewyhairball]

Cool! I’ll try this tomorrow and let you know how I get on.
thanks

Rory

 

[Chewyhairball]

How about like

   With ActiveSheet.ListObjects("Table2")
      .Range.AutoFilter .ListColumns("Type").Index, "=*" & strUserIn & "*"
   End With

Awesome. Works a treat. Thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.