Using a cell reference to nominate which macro to run

[Mr_Natural]

Hi All,

I hope this is a simple one and someone can help.

I have a spreadsheet with a bunch of recorded macros. Each week I run them in a particular order, but that order will vary from week to week (it is based on sports matches). What I would like to do is to be able to run them in an order that is defined by specific cells in a spreadsheet

For example, one week I might have Niners, Jets, Chiefs, Seahawks in cells A1, A2, A3 and A4. What I want to do is run four macros with the same name in that order.

The following week it might be Ravens, Raiders, Colts and Patriots in these cells.

So I guess what I am trying to ask is whether there is a way of using a cell to reference a named macro.

Thanks in advance.

Shaun

[davesexcel]

It will go in chronological order

Please Login or Register  to view this content.

[Mr_Natural]

Thanks for the prompt response Dave - much appreciated.

I'm not 100% sure I understand what you mean. Here is a simple example of what I trying to do - apologies if I have misunderstood your response:

Application.Run "'multimacro.xlsm'!Sorta"

Rather than using the macro name Sorta, if I had Sorta in cell A1, is there a way of using the text in that cell to nominate the macro to run.

Cheers,

Shaun

[davesexcel]

Please Login or Register  to view this content.

[Mr_Natural]

Thanks for taking the time Dave - your help is very much appreciated!