Calling a variable macro

[Hari Prasadh]

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

[Tim Williams]

try

application.run Range("A1").value

Tim
--
Tim Williams
Palo Alto, CA


"Hari Prasadh" <excel_hariNOSPAM@hotSPAREMEmail.com> wrote in message
news:eGtY8dHlFHA.3568@tk2msftngp13.phx.gbl...
> 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
>
>

[Hari Prasadh]

Hi Tim,

Thanks for your help.

Regards,
Hari
India

"Tim Williams" <timjwilliams at gmail dot com> wrote in message
news:%23t87MsHlFHA.3544@TK2MSFTNGP15.phx.gbl...
> try
>
> application.run Range("A1").value
>
> Tim