Clean a string for Range Names – Regular Expressions

I am a big fan of using named ┬áranges in my VBA code. It makes referring to cells in formulas easy, and I can also helps in auditing the code. For instance, I can simply search for “RangeName” (including the quotes) ┬áto see if that particular range name is being used in my code.