Thread
:
executing macros with variable names
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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!
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson