executing macros with variable names
 

Is is possible to execute a macro with a variable in the
name e.g.

a = 1
macro&a
macro&a+1

or something similar. I have a set of macros which I want
to execute depending on some variable. I'm using the format

Case "1"
macro1
macro2
etc.
but this is getting a bit tedious

Thanks!

executing macros with variable names
 

Claude,

You can use Application.Run. E.g.,

Application.Run "Macro" & A+1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Claude" wrote in message
...
Is is possible to execute a macro with a variable in the
name e.g.

a = 1
macro&a
macro&a+1

or something similar. I have a set of macros which I want
to execute depending on some variable. I'm using the format

Case "1"
macro1
macro2
etc.
but this is getting a bit tedious

Thanks!