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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with Reg Pattern "[^"]\$[A-Z]*[0-9]" 3
Multiple Regex Patterns 1
Insert character using Regex 4
Regex Pattern to extract Sheet Name from .Address(external:=True) 9
Help with a regex pattern please 3
Regex Pattern 11
RegEx Replacement patterns 3
Regex Multiple Match not working 3

Back
Top