View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mel mel is offline
external usenet poster
 
Posts: 6
Default Programmatically generate name of functition to call

I want to use a string variable to formulate the name of
the function to call, I can create the name in a string
variable, but how do you use the variable to call the
function.
e.g. Str1=MyFunction1
I tried str1(arg1) and it didnt work.
If I use Myfunction1(arg1) then it works . I know there
must be a special way to call functions if the name is in
a variable. Thanks