Macro to filter out lines
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 .. |
Macro to filter out lines
Pls post your codes in order for us to ascertain the required changes.
-- Hope this help Please click the Yes button below if this post have helped answer your needs Thank You cheers, francis "Ian / ArtistGuitars.com.au" wrote: 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 . |
Macro to filter out lines
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 . |
Macro to filter out lines
Either use:
Equals (or does not equal): ~* (for an exact match of the asterisk) Or use: Contains (or does not contain): ~* The tilde tells excel to treat the asterisk as an asterisk--not a wild card. Same thing with the single character ? (use ~?) and tilde ~ (use ~~). And Edit|Find uses the same technique, too. ======== Ian / ArtistGuitars.com.au wrote: 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 . -- Dave Peterson |
All times are GMT +1. The time now is 05:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com