+ Reply to Thread
Results 1 to 5 of 5

More AutoFilter Problems

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    Albany, NY
    MS-Off Ver
    Excel 2010
    Posts
    45

    More AutoFilter Problems

    Hi everyone! I posted last week regarding an issue with an AutoFilter macro and got some great assistance which fixed the problem. Now, however, I've attempted to expand the capabilities of my macro and I have of course encountered additional problems. Here's my code:

    Please Login or Register  to view this content.
    The problem I'm encountering is still on that last line of code that actually applies the filter. I'm getting the error "Run-time error 1004: AutoFilter method of Range class failed". What can I do to fix this? Thanks in advance for any assistance!

  2. #2
    Registered User
    Join Date
    07-19-2013
    Location
    Albany, NY
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: More AutoFilter Problems

    Surely I haven't stumped everyone, right? I'm sure most of you know more about VBA than I do. I'm still having this issue with my macro - any assistance would be greatly appreciated.

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: More AutoFilter Problems

    Hi DSwatrz

    Add the indicated line of Code...I believe the issue will be apparent...
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    07-19-2013
    Location
    Albany, NY
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: More AutoFilter Problems

    Looks like that fixed it! Thanks!

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: More AutoFilter Problems

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    If this resolves your issue please mark your Thread as SOLVED.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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. Problems with AutoFilter
    By firefly2k8 in forum Excel General
    Replies: 0
    Last Post: 10-28-2009, 10:26 AM
  2. Problems with Autofilter
    By MarkFerbert in forum Excel General
    Replies: 2
    Last Post: 08-04-2009, 11:27 AM
  3. Autofilter Problems
    By frog_monkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2008, 11:11 PM
  4. AutoFilter problems
    By Svea in forum Excel General
    Replies: 2
    Last Post: 04-06-2007, 04:02 AM
  5. autofilter problems
    By dhkmak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2005, 10:38 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