Calling a variable macro
 

Hi,

Can I call name of the macro based on a value in an Excel sheet

Like A1 has "Rename"

Then in VBA can I write

Call Range("A1").value

It doesnt work.

Thanks a lot,
Hari
India

Calling a variable macro
 

try

application.run Range("A1").value

Tim
--
Tim Williams
Palo Alto, CA


"Hari Prasadh" wrote in message
...
Hi,

Can I call name of the macro based on a value in an Excel sheet

Like A1 has "Rename"

Then in VBA can I write

Call Range("A1").value

It doesnt work.

Thanks a lot,
Hari
India

Calling a variable macro
 

Hi Tim,

Thanks for your help.

Regards,
Hari
India

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
try

application.run Range("A1").value

Tim