Results 1 to 3 of 3

How to write Filter criteria code for hidden ERROR value

Threaded View

herukuncahyono How to write Filter criteria... 07-16-2013, 04:30 AM
JosephP Re: How to write Filter... 07-16-2013, 05:12 AM
herukuncahyono Re: How to write Filter... 07-16-2013, 05:17 AM
  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    How to write Filter criteria code for hidden ERROR value

    I have macro code to activate filter:
     Columns("F:F").Select
        Selection.AutoFilter
        ActiveSheet.Range("$F$1:$F$421").AutoFilter Field:=1, Criteria1:=Array("0", _
            "10", "106", "113", "140", "150", "2", "225", "30", "305", "34", "38", "515", "76"), _
            Operator:=xlFilterValues
    Essentially value in the range is the number want to display... an error (# REF!) are hidden
    How to write Filter criteria code as above..
    thanks in advance
    Last edited by herukuncahyono; 07-16-2013 at 05:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Exists or on Error Then - Skip Code- How to write code?
    By Jack7774 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2013, 06:45 PM
  2. Error Occur when write .Range Code
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2012, 09:57 PM
  3. How to write VBA code to filter a field when opening a workbook?
    By checkup2012 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 11:29 AM
  4. how write to rows selected by auto/advanced filter in VBA code
    By xdalibor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 11:28 AM
  5. [SOLVED] Compile error in hidden module: NT Reg Code
    By Nicky Zee in forum Excel General
    Replies: 1
    Last Post: 06-20-2006, 02: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