Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 83
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 83
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calling name of Sheet as a Variable? thekeytothedoor Excel Worksheet Functions 1 January 1st 10 08:48 AM
Calling a procudure through variable name Basu Excel Discussion (Misc queries) 2 August 30th 06 08:55 AM
calling variable within string [email protected] Excel Worksheet Functions 8 May 4th 06 03:07 PM
Calling a sub with a variable... Gary Phillips[_2_] Excel Programming 1 July 13th 04 10:25 PM
variable calling in different modules. russell Excel Programming 2 October 24th 03 04:17 AM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"