+ Reply to Thread
Results 1 to 8 of 8

AutoFilter for a Blank cell

  1. #1
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    AutoFilter for a Blank cell

    How can I convert this code for a blank cell instead of PD & ND?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: AutoFilter for a Blank cell

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    Re: AutoFilter for a Blank cell

    xladept That worked for blanks but I still need to eliminate ("PD", "ND"). I can run both. Thankyou.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: AutoFilter for a Blank cell

    If you want to do both maybe
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    Re: AutoFilter for a Blank cell

    Fluff13...That did the trick. Thanks

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: AutoFilter for a Blank cell

    How can I convert this code for a blank cell instead of PD & ND?
    Mixed message GZ??

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: AutoFilter for a Blank cell

    Quote Originally Posted by gz3s36 View Post
    Fluff13...That did the trick. Thanks
    You're welcome & thanks for the feedback.

  8. #8
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    Re: AutoFilter for a Blank cell

    Yeah Sorry xladept. I posted one and didn't see it come up so I re-posted with a clearer result I was hoping to see. I need to be more patient for posts to appear.

+ 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] How to ignore Autofilter if cell reference is blank
    By sa1ntj0hn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-11-2019, 06:16 AM
  2. [SOLVED] Stop Macro if Autofilter is Blank
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2018, 05:02 PM
  3. How to ignore Autofilter if cell reference value is blank
    By NielPot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2017, 07:58 AM
  4. [SOLVED] Copy top cell post autofilter and re-apply autofilter based on cell value
    By gpato in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2014, 09:07 PM
  5. VBA Code: If Statement If Cell Is Non Blank Autofilter A Column
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2013, 05:24 AM
  6. Autofilter and blank columns
    By tomc2 in forum Excel General
    Replies: 2
    Last Post: 07-14-2012, 04:03 AM
  7. [SOLVED] Can Autofilter Ignore Blank Criteria?
    By RogueArchon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2012, 01:20 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