PC Review


Reply
Thread Tools Rate Thread

Another Problem with Regex Pattern

 
 
ExcelMonkey
Guest
Posts: n/a
 
      30th May 2008
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
 
Reply With Quote
 
 
 
 
keepITcool
Guest
Posts: n/a
 
      31st May 2008
EM:
VB regex (scripting) doesnot support look behind.
kic
--



 
Reply With Quote
 
Ron Rosenfeld
Guest
Posts: n/a
 
      31st May 2008
On Fri, 30 May 2008 14:30:01 -0700, ExcelMonkey
<(E-Mail Removed)> 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 Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regex pattern problem C. Microsoft C# .NET 2 31st May 2008 09:40 PM
regex pattern =?Utf-8?B?QVZM?= Microsoft Dot NET Framework 2 19th Sep 2007 12:24 PM
Help with Regex Pattern =?Utf-8?B?TmF2ZWVu?= Microsoft C# .NET 3 16th Sep 2007 10:29 PM
looking for a RegEx pattern to do this... Jéjé Microsoft VB .NET 4 6th Jan 2005 01:28 PM
RegEx Pattern? Luke Ward Microsoft C# .NET 3 13th Feb 2004 08:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:26 AM.