Re: Regular expressions

On Wed, 19 Sep 2007 12:24:02 -0700, Dave <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

For example I could set a pattern of "[)(*&^]" how would I code it to
exclude those values?

.Pattern = "[^)(*&\^]"

Note the \ that precedes the second ^. The first ^ defines the character
sequence as negative and the \ escapes the second ^ so it's included in the
negative character sequence.
--
*** Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com
.

Loading