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.

What are Volatile Functions in Excel


Excel uses a three stage process to recalculate cells. It first draws a dependency tree, and then lists a calculation chain and then recalculates the cells. Check this link if you are interested in learning more about the recalculation process. Excel determines if a cell’s value depends on another, and decides the order in whichContinue reading “What are Volatile Functions in Excel”