Hi,
Whenever we apply autofilter to a column, we get one check box for BLANK cell.
Is there any way to remove this option from drop down list of autofilter? Particularly via VBA?
Hope someone will be having a solution to this.
Thanks,
xlman
Hi,
Whenever we apply autofilter to a column, we get one check box for BLANK cell.
Is there any way to remove this option from drop down list of autofilter? Particularly via VBA?
Hope someone will be having a solution to this.
Thanks,
xlman
Is there a particular reason why you want to remove it? It can be quite handy to check for missing values in a table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks