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?

 

[Fluff]

What error do you get, as there's nothing wrong with that line of code.

 

[jordanburch]

What error do you get, as there's nothing wrong with that line of code.

runtime error 1004
autofilter mothod of range class failed

 

[Fluff]

Have you changed the data at all, or protected the sheet?

 

[jordanburch]

Have you changed the data at all, or protected the sheet?

So its a concatenate formula that reads off of other formulas before it if this then X type of formulas. Im not sure what you mean about changing the data. I imports 5 files total and add formuals to the end to get x and copy paste that x in that column to a new table as this is the only data i need. It is not protected as far as I know I have not done that.

 

[Fluff]

If you change the criteria back to what it was originally, do you still get the error?

 

[jordanburch]

If you change the criteria back to what it was originally, do you still get the error?

thanks fluff. I will try this in the morning as I have to be somewhere at 430. TTYL!

 

[Fluff]

Ok

 

[jordanburch]

Ok

Hi Fluff

What I did is make the formula into a literal X and it did not change anything. I also tried

ActiveSheet.AutofilterMode = False
Range("AF1:AF").AutoFilter Field:=1, Criteria1:="X"

that didnt work either. Basically I want the af column to filter for X and the range could be shorter or longer depending on the month, IE AF50000 or af 60000.

hopefully that makes sense.

Jordan

 

[Fluff]

Have you converted your data into a structured table?