replacing the Macro name with a variable

[raikar.manish]

Hi,

I have a sheet which contains 1 main macro and 19 sub macros.

from the main macro i need to call any one of the sub macros using the
call function.

However is there any way i can write the names of those 19 sub macros
in a cell and accordingly the macro should be called depending upon
what is the value in the cell.

like.

Call (value in the cell) instead of Call Macro1


Thnks in advance

 

[Bob Phillips]

Application.Run Range("A1").Value

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)