Regular Expressions in VBA


#1

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


#2

Hi Peter,

Not sure, can you send me the workbook or a test file with your script? victor@seotoolsforexcel.com