VBA - AutoFilter - 'nonblank'
I have an Autofilter. I want to be able to toggle the current filter on and
off. I already have a mechanism in place that does this. however, it does
not work when one of the columns is filtered for "Blanks" or "nonblanks". A
workaround is to explicitly custom filter for equal "" or not equal ""...
but it seems a little roundabout. I have not found any help in the object
browser or the Help files.
Any help would be appreciated. Thanks!
|