+ Reply to Thread
Results 1 to 3 of 3

vba excel auto filter to always include blank

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    petrolia, pa
    MS-Off Ver
    10
    Posts
    11

    vba excel auto filter to always include blank

    need the total row to always be visible when a user filters on their name. Currently the total row is blank 'A' thru 'T' and the filter column is 'O' totals are maintained for columns 'U' thru 'AF'.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: vba excel auto filter to always include blank

    Hello
    Can you upload sample workbook?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    05-10-2016
    Location
    petrolia, pa
    MS-Off Ver
    10
    Posts
    11

    Re: vba excel auto filter to always include blank

    I went to manage attachments and uploaded but I'm not confident that you will see it, let me know. The filter selection will be on sales district which is in column 'O' which is where 'blank' always must be selected as well so that the total row shows at all times.
    Thanks
    Attached Files Attached Files

+ 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. VBA Auto Filter - Stop when all cells blank
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2018, 09:46 PM
  2. Excel 2016 : Get & Transform - Add Column that include blank cell
    By Ohhaa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-14-2017, 09:25 AM
  3. Replies: 1
    Last Post: 04-05-2016, 10:35 AM
  4. How to add a criteria for blank cells for the auto filter
    By behnam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2013, 12:36 PM
  5. [SOLVED] E-Mails auto generated in Excel just to not include blank rows
    By srands in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2012, 01:37 PM
  6. Find first blank cell after Auto Filter
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-05-2010, 11:39 AM
  7. Auto Filter out text or blank rows
    By D Hafer - TFE in forum Excel General
    Replies: 8
    Last Post: 07-01-2005, 08:05 AM

Tags for this Thread

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