Have you ever wondered why there are two properties called “Name” for a spreadsheet? Go ahead, open up the Visual […]
Tag Archive for ‘VBA’
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 […]
Excel Worksheet Functions and VBA Functions
Many excel users might not be aware of the subtle distinction between Excel Worksheet functions and VBA functions. Majority of […]
Introduction to Regular Expressions in VBA
Regular-Expressions (RegExp) is something I bumped into when my string manipulation requirements jumped to an advanced level. Before I started using this […]
Reversing a string in Excel
In my many years of rummaging through the internet for help, I have seen countless posts where troubled help seekers […]
