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
--
donwb

One way:

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

Is Thisworkbook ok?

donbowyer wrote:

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
--
donwb

--

Dave Peterson

Hi Dave
That works perfectly.
Many thanks

--
donwb


"Dave Peterson" wrote:

One way:

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

Is Thisworkbook ok?

donbowyer wrote:

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
--
donwb

--

Dave Peterson