Thread: Another Problem with Regex Pattern
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Another Problem with Regex Pattern
On Fri, 30 May 2008 14:30:01 -0700, ExcelMonkey
wrote:

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

Neither VBScript nor Javascript support look-behind assertions.
--ron
Reply With QuoteReply With Quote