Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 .. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter on blank lines | Excel Discussion (Misc queries) | |||
Auto filter on blank lines | Excel Discussion (Misc queries) | |||
How do I filter out lines in a range? | Excel Discussion (Misc queries) | |||
how i do to make a self filter in more than 3000 lines? | Excel Worksheet Functions | |||
Counting lines when using a filter | Excel Discussion (Misc queries) |