Running a Macro based on a cell reference

[JLeith]

I have produced 3 marco's to copy cells and paste them into another location.

When I assign the macros 1 by one to a gif image the copy and past works.

What I would like to do now is have a macro that can run run and based on the value run the corresponing Macro.

I have Macro9, Macro10, Macro11.

I have MarcoRead as what I call the Master Read.
I think I have the code correct at least it does not fail.

When I enter say 9 in cell O1 and run the MacroRead it does not run Macro9 and the same if I enter 10 or 11 in cell O1.

I'm using the little Blue guy as my trigger for MacroRead

I'm trying to google the flow but not find simular tasks.

John

[MarvinP]

Hi John,

Is Roster a number or text? Your code doesn't know either.
How about doing a:

Dim Roster as Double
Roster = Range("O1").Value

and then see what happens from there.

If you wanted to get fancy you could also use a Select Case construct for your code.

Look at:
http://www.ozgrid.com/VBA/select-case.htm

[JLeith]

Hello MarvinP
Thank you for the "Value" vs my Select.

It is working nicely.

John