+ Reply to Thread
Results 1 to 10 of 10

Run-Time Error 1004 Auto Filter of Range class failed

  1. #1
    Registered User
    Join Date
    11-28-2010
    Location
    India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    81

    Run-Time Error 1004 Auto Filter of Range class failed

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by sryadav12; 12-11-2019 at 05:33 AM. Reason: forget to put in code

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    Where is the data in each of the sheets you are filtering? Does it start in A1, or A2, or somewhere else? Also, is it normal ranges, or set up as Tables on each sheet?
    Rory

  4. #4
    Registered User
    Join Date
    11-28-2010
    Location
    India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    81

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    Hello rorya,

    Please find the attached file for testing.

    My results should be whatever Vendor selected in Sheet 1 Cell M9 (Vendor Name) the same vendor should be filtered in all sheets by skipping first summary sheet.

    As per the code the filter should take on two columns (One is Vendor (selected on Sheet1 Cell M9) and other on Bal Qty (should be greater than zero).


    Regards
    Santy
    Attached Files Attached Files
    Last edited by sryadav12; 12-20-2019 at 02:43 AM.

  5. #5
    Registered User
    Join Date
    11-28-2010
    Location
    India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    81

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    Hello Guys,

    Please help on the common Filter range issue.


    Regards Santy
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 02-10-2020 at 10:17 AM. Reason: Removed urgency

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    Now you seem to have overlooked the forum rule on cross-posting (both here and elsewhere), so please add the relevant links.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    @sryadav
    Is your last post related to the original thread?

    Administrative Note:
    Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    Administrative Note:

    Last warning !! Any other infraction to our rules will be followed by a temporary withdrawal of your posting privileges

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

  9. #9
    Registered User
    Join Date
    11-28-2010
    Location
    India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    81

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    I am sorry for violating the Forum rule of cross-posting unintentionally. .

    I hope I get help on the same.

  10. #10
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Run-Time Error 1004 Auto Filter of Range class failed

    If you add a link to your cross post as requested...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run time error 1004 Auto filter Method of Range class failed
    By chillz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2017, 10:01 AM
  2. Run-time error '1004': PasteSpecial method of Range class failed
    By drgkt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2015, 04:01 PM
  3. [SOLVED] Run Time Error '1004': Select method of Range Class failed VBA
    By jcgonzales in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2014, 01:39 AM
  4. Run Time Error '1004': Select method of Range Class failed VBA
    By jcgonzales in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2014, 02:29 PM
  5. Run-time error '1004': Select method of Range class failed.
    By pspikym90 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-19-2012, 06:15 PM
  6. Run time error 1004 - PasteSpecial of Range class failed
    By Niciana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2012, 11:45 AM
  7. Run time error '1004' Autofill method of Range class failed
    By lanie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2009, 08:30 AM

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