Break Down Your Macro Into Steps - Pt1: Design

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.
*Watch Next*
https://youtu.be/CY6ww4_aSjk

In Part 1 (this video), I share with you 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 that they can run individually from one central worksheet.
In Part 2, 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 - Pt1: Design канала XLWizardry