Speeding up VBA Code using Calculation Mode

One of the most common requests from people writing VBA code in Excel is “how do I speed up my VBA code?”. The Speeding up VBA Code series aims to give you some quick and easy to implement techniques to speed up your code. In this free beginner level Excel tutorial we use Microsoft Excel…

Goal Seek in Excel … Done Correctly!

Building a spreadsheet that uses Goal Seek to get to the end result is relatively easy. Doing it well takes a bit more work. In this beginner level tutorial we start with a typical spreadsheet that uses Goal Seek. It works but it’s difficult for a new user to follow and figure out what they…

How to Create a Custom Visual Basic Editor Toolbar

A good workman always knows his tools and in this tutorial I show you how to create your own custom toolbars in the Visual Basic Editor. It’s a free beginner level tutorial and I use Microsoft Excel 2016. The video uses MS Excel 2016 but the same steps are used for MS Excel 2010, Excel…

Dynamic Named Ranges in Excel

A great way of making your macros and code more robust is to use dynamic named ranges. These automatically adjust and resize as the underlying data changes and I use them whenever I can. In this beginner level tutorial we start with a completely blank spreadsheet. We build a number of lists within a worksheet…