Excel VBA Code for Filtering

shrav

New member
Local time
Today, 13:50
Joined
Oct 21, 2017
Messages
5
Hi Guys, can someone help me on VBA Code for excluding multiple texts through filter?


Sent from my iPhone using Tapatalk
 
Provide some details and I am sure someone would be willing.
 
Usually we use Criteria1:=“<>something”


to exclude SOMETHING in filter but it’s working to exclude for two items only. So I need a way to exclude more than two texts


Sent from my iPhone using Tapatalk
 
If you can use a query then use Not In('Red',Green','Something')
 
I have tried but not working


Sent from my iPhone using Tapatalk
 
Before we make too many assumptions here, we need to know a little bit more of what is going on.

Are the things you want to exclude always the same or is there a way for them to differ from one time to the next?

Are you always attempting to exclude from the same field or can the field differ from one time to the next?

Do you always attempt to filter from one field at a time or can your multiple exclusions apply to multiple fields?

Try to keep the answer in common business English and avoid the temptation to provide us with jargon.
 
Use
Range.autofilter

Search for syntax
 

Users who are viewing this thread

Back
Top Bottom