View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Another Problem with Regex Pattern

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