Call procedure using variable

[Guest]

I need use an expression, which has been derived as a variable in a code
procedure, to call a Subroutine of the same name.
The Sub Routine will have a name eg MyZ7 derived from:-
MyName="My" & Range("A1").Value where A1 contains "Z7"
this produces "MyZ7" OK but the problem is that if I now write:-
"Call MyName" I get an error message "Compile Error expected Procedure not
Variable"
There must be a way around this: help please

 

[Dave Peterson]

One way:

application.run thisworkbook.name & "!" & myname

Is Thisworkbook ok?

 

[Guest]

Hi Dave
That works perfectly.
Many thanks