+ Reply to Thread
Results 1 to 3 of 3

Uncheck Only Two string form auto filter

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Uncheck Only Two string form auto filter

    hi,
    i have data in c10:d50

    i want to hide only these two string "SLT CHRG" and "SLT CHRG" from range d10:d50

    i mean uncheck only two string from the filter
    RE.jpg
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,462

    Re: Uncheck Only Two string form auto filter

    Maybe use a Text Filter and select Not Equal "SLT CHRG"
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Uncheck Only Two string form auto filter

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. [SOLVED] Uncheck one Box, uncheck others in a User Form
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2013, 01:44 AM
  2. [SOLVED] Form Control CheckBox check/uncheck via code
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-18-2013, 02:41 PM
  3. Using the auto-filter selection form on arrays
    By Perception in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2011, 06:59 AM
  4. [SOLVED] Pivot chart won't refresh when I uncheck filter boxes
    By Dr Martin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-02-2010, 11:46 AM
  5. Uncheck pivot rowfileld's items dropdown filter ?
    By narendramaruti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2009, 03:31 PM
  6. Auto filter list by form selection, VBA
    By fossi19 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-10-2009, 07:14 AM
  7. Checkbox on form won't uncheck
    By beckstei in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2007, 01:55 PM

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