| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine macros variable help | Excel Worksheet Functions | |||
| Dummy variable in macros | Excel Discussion (Misc queries) | |||
| Macros with variable data | Excel Worksheet Functions | |||
| Executing Macros | Excel Discussion (Misc queries) | |||
| Executing of excel Macros. | Excel Discussion (Misc queries) | |||
Linear Mode
