allow for does not equal for auto-filter, when inserting into VBA
Over the years, I've found that I needed a filter, which I could modify, using VBA, that would allow me to filter more than a single component when I'd activate it. Last year, I posted on the MSDN-Excel for Developers forum, and one member gave me a sample which I modified, and got to work for my purposes.
I took his sample, made the changes, and now have an excellent filter tool (I posted my final solution, and have made several using different numbers of components), and thanks to VBA, I can add, remove, increase, reduce, etc... my filtering capabilities, as needed.
The other day I found that the basic autofilter would not allow me to filter based on the does not contain or does not equal options in the way I wanted/needed. I thought about it, and recorded a macro, using the filter, and the "does not contain" option. I then took that, applied it to my filter macro, and found it did not work. I posted back on the forum, discussing my problem, and learned that the Autofilter tool and the options I used are incompatible, and do not work together.
As such, I'd like to ask for some work on your guys' end to change this option to allow us to gave full usability for autofiltering with VBA.
is my most recent foray, and attempt to use the "does not contain" option for the autofilter. Eg.
Criteria1:="<>" & arr & ""
where I could expand the criteria to include more than a single element. Presently, my existing code shows the Criteria1:= arr
Why could I not also add standard coding elements to expand its operability?
As you know, the "<>...." would be the recorded results for the "does not contain" option. It seems an easily accomplished transition to code a variable where the '....' would be, giving what I have above in my sample.
In all honesty, while I'm told I keep pushing the envelope with the ideas I come up with, I know I cannot be the first one to think about this. Please review, and act on this.... my filtering needs are clamoring for it to work, and the other solution is too limiting.
This would be incredibly helpful to have.