+ Reply to Thread
Results 1 to 5 of 5

Run Time Error 1004: Autofilter method of range class failed

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    86

    Run Time Error 1004: Autofilter method of range class failed

    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:

    Please Login or Register  to view this content.
    Can someone tell me how I can fix this problem? Thnx.

    -HP RodNuclear
    Last edited by HP RodNuclear; 12-15-2010 at 11:58 AM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Run Time Error 1004: Autofilter method of range class failed

    I just ran this code with 2003 and there was no error.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Run Time Error 1004: Autofilter method of range class failed

    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.

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    11-04-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    86

    Re: Run Time Error 1004: Autofilter method of range class failed

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

    Please Login or Register  to view this content.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Run Time Error 1004: Autofilter method of range class failed

    Hi,

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

    Rgds

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1