Call procedure using variable

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
>