Another Problem with Regex Pattern

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelMonkey - 30 May 2008 22:30 GMT

Why would this not be working in VBA? There are not any double quotes in the
pattern itsleft. I am getting a Run-time 5017 Run-Time error.

(?<!')\$?[A-Z]\$?\d+(:\$?[A-Z]\$?\d+)?

Thanks

EM

Reply to this Message

keepITcool - 31 May 2008 10:59 GMT

EM:
VB regex (scripting) doesnot support look behind.
kic
--

Reply to this Message

Ron Rosenfeld - 31 May 2008 14:53 GMT

>Why would this not be working in VBA? There are not any double quotes in the
>pattern itsleft. I am getting a Run-time 5017 Run-Time error.
[quoted text clipped - 4 lines]
>
>EM

Neither VBScript nor Javascript support look-behind assertions.
--ron

Reply to this Message