View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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