Regular Expressions in VBA


I have downloaded the Reg Ex tools as I wanted to process cells in a worksheet that match a pattern: it works fine if type =RegExFind(...) in the formula bar, but I want to be able to use reg ex in a script that is attached to a button on the spreadsheet, and when I put RegExFind in the script I get a compile error. Have I done, or not done, something, is there a version that works in VBA scripts?
Thanks, Peter


Hi Peter,

Not sure, can you send me the workbook or a test file with your script?