Pass Macro Number into sub routine...

[KanMan]

I would like to use the Macro number (such as the 5 in Macro5()) and pass it into another routine thereby automating it even further. Is this doable? Is there a line of code that I can use that will let me know what the number is? and then to use pass into an array. Thanks.

 

[BrianB]

Just use another variable. eg

Dim MacroNumber As Integer
Macro4 has the line MacroNumber = 4
Macro5 has the line MacroNumber = 5