Hi, @ChrisQ. Glad @Nige_S was able to help you out.
Sorry about my non-helpful response above. I failed to carefully read your original question.
On a related front, however, you might find this macro useful: Edit a Recently Executed Macro
The macro can be used to edit or run a recently executed macro.