auto filter when equal to x

[jordanburch]

hey guys im having an error when it hits this line of code

ActiveSheet.Range("$A$1:$AF$65171").AutoFilter Field:=32, Criteria1:="=X"

it used to be

ActiveSheet.Range("$A$1:$AF$65171").AutoFilter Field:=32, Criteria1:="<>"

basically I only want it to filter for x in that column. Can anyone help?

 

[jordanburch]

Have you converted your data into a structured table?

No I have not, but I will mention there are filters on the headers up to the U column. Do the other columns after that need to hae that filter for this code to work?

 

[Fluff]

Ok, how about

If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
ActiveSheet.Range("$A$1:$AF$65171").AutoFilter Field:=32, Criteria1:="=X"

 

[jordanburch]

Ok, how about

If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
ActiveSheet.Range("$A$1:$AF$65171").AutoFilter Field:=32, Criteria1:="=X"

works great thanks! Do I have to turn back on autofiltermode? I appredciate your help!

 

[Fluff]

Do I have to turn back on autofiltermode?

Not unless you want to.