View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Syntax of this code

You are looking at regular expressions.

Take a look at

http://msdn.microsoft.com/library/de...ting051099.asp
Microsoft Beefs Up VBScript with Regular Expressions

--
HTH

Bob Phillips

"ExcelMonkey" wrote in message
...
Can someone tell me what this snippet of code means? What is the role of:

1) [
2) ^
3) +
4) (


Const Words As String = "[^a-z]([A-Za-z0-9$]+)"

Thanks