it's hard to say what you want.
..AutoFilter field:=1, Criteria1:="<", Operator:=xlAnd
but i suggest you do a replace of the asterisk because it's a valid
wildcard. i used the ! here.
ActiveSheet.Range("$A$5:$K$228").AutoFilter Field:=5, Criteria1:= _
"<*" & "!" & "*", Operator:=xlAnd
this would filter all records that do not have an !.
--
Gary Keramidas
Excel 2003
"Ian / ArtistGuitars.com.au" <Ian /
wrote in message
...
Hi I have written some macros and im having a problem excludinjg certain
lines in my worksheet.
I use the filter option. But I want to be able to filter out lines that
have"*" in them using a macro.
How do I change the filter to "not equal" ?
Ian / Artistguitars.com.au
.