Filtering Table based on Column Header

[Yorke]

Hi all,

Is it possible to filter a table based on the column header? All I can find is based on Field position (i.e. column number 23), but my column is not in a set position. I've seen a method which calculates the column position but this involves selecting where the table will be, and this is not set either (sorry!! It's not my file...)

The table is called "ZVA", in Worksheet 'Data', Table Header is 'Div', Filter on 'NS'

Thanks in advance

P.s. This is my current method which doesn't always work...
OpenBook.Worksheets("Data").ListObjects("ZVA").Range.AutoFilter Field:=23, Criteria1 :=Array("NS"), Operator:=xlFilterValues

 

[Fluff]

How about

   With OpenBook.Worksheets("Data").ListObjects("ZVA")
      .Range.AutoFilter Field:=.ListColumns("Div").Index, Criteria1:="NS"
   End With

 

[Yorke]

Brilliant, thank-you!

Just an add-on, how would I modify this code to filter this column to show "NS" and "SS"? In my previous method I was able to use:
Criteria1 :=Array("NS", "SS")

For future use, should this be a new thread?

 

[Fluff]

How about

   With OpenBook.Worksheets("Data").ListObjects("ZVA")
      .Range.AutoFilter .ListColumns("Div").Index, Array("NS", "SS"), xlFilterValues
   End With

 

[Yorke]

Thank-you!!

 

[Fluff]

You're welcome.