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