Calling a sub method

[richcoleuk]

Hi,

I have the name of my sub method stored in a variable:

mySubMethodName = "do_something"

I then want to call this method using the variable, I have tried
the following but it doesn't work:

Call mySubMethodName

Is there anyway to do what I am trying to do?

 

[Christian]

Hi,

I have the name of my sub method stored in a variable:

mySubMethodName = "do_something"

I then want to call this method using the variable, I have tried
the following but it doesn't work:

Call mySubMethodName

Is there anyway to do what I am trying to do?

Why don't you just use

Call do_something

Christian

 

[richcoleuk]

because the name of the sub method is specified on the worksheet, and
this value is taken from the sheet.

 

[NickHK]

richcoleuk,
Application.Run ?

NickHK

 

[Bob Phillips]

Application.Run variable_name

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[richcoleuk]

Works a charm, thanks Nic