Break Down Your Macro Into Steps - Pt2: Coding

When designing macros for a substantial set of requirements, rather than having one macro that does everything, I break things down into smaller functional units of work each with a well defined purpose. This makes the code easier to understand, manage and troubleshoot.

In Part 1, I showed how I determine what these functional units will be and how I present them to the user as a step-by-step series of macros they can run.
In Part 2 (this video), I show the code behind some of these macros.

*Excel Version*
* Recorded using Excel Pro Plus 2021 (I use at home) but also applies to Microsoft 365 (I use in the office)
* You cannot run VBA/Macros directly in Excel online

*Excel Tips Playlist*
https://www.youtube.com/playlist?list=PL8zztIrMXMC7H595kmYDJF_yFE0JNk2OW

Видео Break Down Your Macro Into Steps - Pt2: Coding канала XLWizardry