Another Problem with Regex Pattern

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
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
Click to expand...

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