+ Reply to Thread
Results 1 to 2 of 2

Advanced Filter Error

  1. #1
    Registered User
    Join Date
    Atlanta, GA
    MS-Off Ver
    Excel 2007

    Advanced Filter Error

    For some reason I am receiving the following error when trying to write an advanced filter "Method 'Range' of object '_Global' Failed"
    Weird thing is I have virtually the same code(the dynamic range and advanced filter part) in a another macro with just different names and it works fine there. The purpose of the filter is to display on the FICA OOBs sheet only items in the WT column of /403, /404, /405, /406 and the FICA OOBs column with a value < 0 using the criteria on the Filter_Criteria sheet. The range of the filter is a named Range I created based on the FICA OOBs sheet.

    Please Login or Register  to view this content.
    Thanks for nay help,

    Last edited by csh8428; 09-06-2012 at 03:13 PM.

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019

    Re: Advanced Filter Error

    Hi csh8428
    Can't test your code...no workbook attached. This line of code will raise a #REF error in the Named Range
    Please Login or Register  to view this content.
    If you have spaces in the Worksheet Name when naming ranges you need to wrap the Sheet Name in single quotes
    Please Login or Register  to view this content.

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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