I have a fairly extensive VBA code (75+ lines) that I would like to use in two different situations.
The code for the second situation would be the same as the first except for a few additional lines of code.
The first code uses a macro key combination (Ctrl-Shft-s) to call it.
I would like to call the second code with its own macro key combination ((Ctrl-Shft-u).
Ideally I would like to use the first macro's code and then jump to a second section to deal with the second situation.
So here's the problem.
How can I use the Ctrl-Shft-u to run the second macro, when I want to run the first code and then jump?
Of course I know I can just copy all of the first code into the second macro, but I'm looking for a more efficient way to do this.
TIA
Bookmarks