View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claude Claude is offline
external usenet poster
 
Posts: 6
Default 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!