Another Problem with Regex Pattern

's Computer Specifications

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

's Computer Specifications

EM:
VB regex (scripting) doesnot support look behind.
kic
--

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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