I’ll be straight with you: I thought we’d get this mini-series finished with this third video!  In the end, however, I thought it better to split the last part into two: the first part is about writing what’s called ‘pseudo code’; the second about implementing and testing the macro.  Both stages are critical in Excel VBA development.

Pseudo code is a set of instructions that describes, step-by-step, the function of a computer programme written in English (or your native language.)  The purpose of pseudo code is to make it crystal clear in your mind what the macro should do, by divorcing the conceptual challenge of how the code works from the technical challenge of expressing those ideas programmatically.  In this video, we’re in the conceptual world.  Think of it as like drawing up a blueprint for your macro.  You wouldn’t try to build a house with a set of plans – let’s apply that same ‘design’ mindset to your Excel development.