Dim xMacro
xMacro = "ApplicationName"

Application.run xMacro


Sub Macro1(x, y)
MsgBox x & " " & y
End Sub

Sub Macro2()
Dim xMacro
xMacro = "Macro1"
Application.Run xMacro, "StringArg1", 29
End Sub

--
Regards,
Tom Ogilvy


"Jack Adams" wrote in message
...
Is there a way to store the name of a macro (with or
without parameters) in a named variable and then activate
the macro using the variable reference name?

Thanks,

Jack

This doesn't work but is waht I am trying to accomplish

Dim xMacro
xMarco = "ApplicationName"

Application. run ApplicationName

Likewise for a macro with parameters