Filtering multiple values in one column?

[hreyo25]

Hello all I am trying to set up a spead sheet that will filter multiple values in one column. I have figured out a way to filter one value, but am stuck filtering more then one.
I am using the code below.

For example:
ActiveSheet.Range("$A$6:$T$15000").AutoFilter Field:=1, Criteria1:= _
"=Square*", Operator:=xlAnd

this will filter anything that starts with the word square. How would i get to filter out the cells with the word Square and Circle. Any help would be appreciated.

 

[lohithsriram]

Hi Hreyo25,

Change your line of code with this.

ActiveSheet.Range("$A$6:$T$15000").AutoFilter Field:=1, Criteria1:= _
"=Square*",  Operator:=xlOr, Criteria2:="=Circle*"

 

[hreyo25]

Thank you so much