Hi William,

I'm a little late on this one, I was just doing a quick browse through
the RegExp questions

You can enable iRegExo with early binding as per Chip's suggestion or
you can use late binding as below

Dim RegExp As Object
Set RegExp = CreateObject("vbscript.regexp")

As it is a distribution I'd stick with the early binding as your RegExp
reference will be included with your file, but when I give code to
someone else I use late binding as its one less thing that the user
needs to set up


Cheers

Dave


---
Message posted from http://www.ExcelForum.com/