VBA - Using Range Names Instead of Column Numbers

[350Z Pilot]

I am trying to use a Range Name instead of a Column# (Field#)

Instead of this:
Application.Goto Reference:="Sheet1"
ActiveSheet.Range("$A$1:$GZ$999999").AutoFilter Field:=137, Criteria1:="Y"

I would like to use a Range Name like this:
Application.Goto Reference:="Sheet1"
ActiveSheet.Range("$A$1:$GZ$999999").AutoFilter Field:="T_Restricted_List", Criteria1:="Y"

My columns can be moved without my knowledge so a macro using a Column Count is vulnerable. A Range Name will move with the columns in a predictable manner.

Thanks

 

[Domenic]

Try...

ActiveSheet.Range("$A$1:$GZ$999999").[B]AutoFilter Field:=Range("T_Restricted_List").Column[/B], Criteria1:="Y"

Hope this helps!

 

[350Z Pilot]

Thanks Doc!
That worked perfectly.

 

[Domenic]

You're very welcome!