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
|