none
get Blanks as second filter option below 'Select All'? RRS feed

  • Question

  • Hi

    Just wondering if there is any way to get 'Blanks' as second filter option below 'Select All'?

    Most of the time I'm dealing with columns with a lot of values, so blanks as second option would save me from having to scroll down that box all the time.

    Cheers

    Wednesday, November 9, 2016 4:55 AM

Answers

  • Hi,

    To filter blank for your columns, you could use Criteria1:="="

    E.g.

      ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1, Criteria1:="="

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by PHEC Monday, January 30, 2017 6:27 PM
    Thursday, November 10, 2016 2:24 AM
    Moderator