On Tue, 27 May 2008 08:59:01 -0700, ExcelMonkey
wrote:

I am having a problem usng this regex pattern in VBA:

[^"]\$[A-Z]*[0-9]

When I put it into quotes:

"[^"]\$[A-Z]*[0-9]"

It highlights the first ] and says Invalid Character.

I am assuming that it has something to do with the way VBA uses quotes for
text strings. What do I have to do to get around this?

Thanks

EM


"[^""]\$[A-Z]*[0-9]"

should work just fine.

--ron