replacing the Macro name with a variable

  • Thread starter Thread starter raikar.manish
  • Start date Start date
R

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
 
Application.Run Range("A1").Value

--
---
HTH

Bob


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top