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.

Range Navigator – Smarter Navigation for Excel

My previous Excel Navigation add-in fetched a few fans; I got a lot of positive feedback on LinkedIn. I designed it to help people working on enormous spreadsheets. I then realized that big workbooks usually host many sheets. I received a few requests to add worksheet selection functionality into the form. Nothing makes me happier than toContinue reading “Range Navigator – Smarter Navigation for Excel”

Local trumps Global – Local Named Ranges make the spreadsheet more tractable

Creating user friendly spreadsheets is not just a professional courtesy anymore. We have the obligation to help users decipher the spreadsheet we so hastily put together. Spending a little extra time setting up well designed spreadsheets help a firm reduce future costs by reducing the time spent on testing and scrutinizing the sheet. improving theContinue reading “Local trumps Global – Local Named Ranges make the spreadsheet more tractable”