Old Code - Seems to be acting differently

[kgkev]

After at least 2 years of running the same report one of my output files is no longer correct.

I have narrowed this down to a single line of code that seems to be acting incorrectly.

Sheets("Chasing").Range("$A$4:$Z$955").AutoFilter Field:=4, Criteria1:="*W*"

I believe this should be apply the filter to column "D" however the filter is applied to "E"


If I change the code...

Sheets("Chasing").Range("$A$4:$Z$955").AutoFilter Field:=3, Criteria1:="*W*"

It works as it used to.

Out of interest I changed field to 2 and 1 which now corresponds to column C & B.
It is not possible for me to apply the filter to column "A"

I have created a new book with a small sample of data and the original code works as it should.


This doesn't seem right, any ideas?

 

[RoryA]

Probably not without seeing the workbook. Is there a dropdown at the top of column A?

 

[kgkev]

WOW!!!

Manually removed the filter. Changed the code back to field 4...works perfect.