Run Time Error 1004: Autofilter method of range class failed

[HP RodNuclear]

Hello all,

I am working on a project in Excel 2010/2007 however the final product will be utilized on a computer that has Excel 2003. I say all this because I think this is the culprit for this error message:
[/B]Run time error '1004' Autofilter method of Range class failed[/B]
and when I debug, it points me to this part of the code:

Range("A3:W3").Select
        Selection.AutoFilter
        With Selection
            .AutoFilter _
            Field:=2, _
            Criteria1:=DItem 'this set the fist filtered data for the value
        End With

Can someone tell me how I can fix this problem? Thnx.

-HP RodNuclear

[Mordred]

I just ran this code with 2003 and there was no error.

[Richard Buttrey]

Hi,

Is the sheet containing the A3:W3 range you are trying to filter the Active sheet when you run this macro? If not try explicitly including the sheet name. i.e. (and note that you don't need the .Select statement.

Sheets("yourSheetName.Range("A3:W3").AutoFilter, Field:=2, Criteria1:=DItem 'this set the fist filtered data for the value

[HP RodNuclear]

I tried changing the code to match what you suggested but I still get the same error message. This is what I put:

Sheets("By Department").Range("A3:W3").AutoFilter , Field:=2, Criteria1:=DItem

[Richard Buttrey]

Hi,

Would you upload your workbook - or at least a suitably anonymised version of it.

Rgds