Another Problem with Regex Pattern

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
 
R

Ron Rosenfeld

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
Regex Pattern to extract Sheet Name from .Address(external:=True) 9
Help with a regex pattern please 3
Regex Pattern 11
Insert character using Regex 4
Multiple Regex Patterns 1
Regex Multiple Match not working 3
RegEx Replacement patterns 3

Top