Excel VBA Code for Filtering (1 Viewer)

shrav

New member
Local time
Today, 03:27
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
 

BigHappyDaddy

Coding Monkey Wanna-Be
Local time
Yesterday, 20:27
Joined
Aug 22, 2012
Messages
205
Provide some details and I am sure someone would be willing.
 

shrav

New member
Local time
Today, 03:27
Joined
Oct 21, 2017
Messages
5
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
 

Minty

AWF VIP
Local time
Today, 04:27
Joined
Jul 26, 2013
Messages
10,371
If you can use a query then use Not In('Red',Green','Something')
 

shrav

New member
Local time
Today, 03:27
Joined
Oct 21, 2017
Messages
5
I have tried but not working


Sent from my iPhone using Tapatalk
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 22:27
Joined
Feb 28, 2001
Messages
27,179
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.
 

Cronk

Registered User.
Local time
Today, 13:27
Joined
Jul 4, 2013
Messages
2,772
Use
Range.autofilter

Search for syntax
 

Users who are viewing this thread

Top Bottom