• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

When double click how can i make it work coexist.

K

kalua1231

Member
I want the following code to do what is program to do, but to also look for another word. If in need of more clarity or in depths example like pictures etc please ask, will do. Thanks again Chandoo for your time

The word i want the bottom code to work is ("DIVIDER"). How will i set it up to look for this word in addition.

ActiveSheet.ListObjects("Table134").Range.AutoFilter Field:=5, Criteria1:=Selection.Text
 
Hi ,

Your problem description is not clear to me.

Suppose the cursor is placed in a cell which has the word WORKSHOP.

What should the criteria be ? Should it be the two words WORKSHOP and DIVIDER ( or logically speaking WORKSHOP or DIVIDER ) ?

Will the selection be only one cell , or can it be more than one cell ?

Narayan
 
Hi ,

Try this :

ActiveSheet.ListObjects("Table134").Range.AutoFilter Field:=5, Criteria1:=Selection.Text , Operator:=xlOr , Criteria2:="DIVIDER"

Narayan
 
You must log in or register to reply here.
Back
Top