The biggest downside to working in massive corporate offices is the locked down computer systems. There is no internet access, no games, […]
Tag Archive for ‘Source code’
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 […]
List Files in a Folder and Rename them – Batch Renamer
Some of the tasks I had to do at work involved running a couple of “master” spreadsheet models every month […]
Extract the Nth word in a String in Excel
Visual Basics for Applications (VBA) allows users to build on the existing functionality of Microsoft Excel. It comes with a […]
Concatenate a Range of Strings in Excel
Most of us have used the Concatenate() function in Excel. It is a neat function that saves you the trouble […]
