Handson

-  I have found the below in most of the places in macros, what it is:  - --- Solved

[$ClarityReporting].[Master Project Name] -

> It means that you are pulling Master Project Name details from ClarityReporting Sheet.

- 6/15/15: Regular Expression in vbscript to filter the records with the director name "Ben" in them:

Issue: I tried to use "*" - regular expression as mentioned in teh below code:

Ben= "Heermance"
ActiveSheet.Range("$A$1:$CN$25425").AutoFilter Field:=28, Criteria1:=Array( _
"Goel Vikas", "*" & Ben & "*", "Radmand Payman", "Ray Michael H", "Tiku Sripriya" _
, "Wilson Sheila K"), Operator:=xlFilterValues

But looks like regular expression does not work just like that.