executing macros with variable names

[Claude]

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!

 

[Chip Pearson]

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 (e-mail address removed)