Excel VBA Common Question: What is ‘Option Explicit’ for?

From time to time I thought I would post answers to the most common questions I get asked during the classroom based courses that we run. We will also do this for the online Excel courses and also feel free to ask questions READ MORE

Creating your own formula (User Defined Functions)

The range of formula within Excel is great. Most of the day to day functionality that you need is there but if you find that you need to do a different calculation that is not built in then you can create what is READ MORE

Recording a simple macro to save yourself repetitive work.

Introduction The whole area of macros in Excel can be an intimidating area to start with but some things can be very straightforward. I thought it would be useful to publish some useful tips on our blog to give you a taste of READ MORE