Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Macros from a list
I have a number of procedures in a module, however I would like to these to
be called from another module in a sequence determined by the contents of a worksheet range. So for example if the Range named ProcessList contained the following....... Report1 Report2 Report3 my code would look like this........ with Range("ProcessList") for ir = 1 to .rows.count Call .rows(ir,1) <<<<< what do I put here next ir end with What is the syntax to pass the value determined by the range row to the procedure name? TIA Nigel ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Macros from a list
For each cell in Range("A1:A10"
Application.Run Thisworkbook.Name & "!" & cell.value Next -- Regards, Tom Ogilvy "Anonymous" <Nobody wrote in message ... I have a number of procedures in a module, however I would like to these to be called from another module in a sequence determined by the contents of a worksheet range. So for example if the Range named ProcessList contained the following....... Report1 Report2 Report3 my code would look like this........ with Range("ProcessList") for ir = 1 to .rows.count Call .rows(ir,1) <<<<< what do I put here next ir end with What is the syntax to pass the value determined by the range row to the procedure name? TIA Nigel ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALLING MACROS FROM A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
calling macros from worksheet to another | Excel Discussion (Misc queries) | |||
Calling macros in another workbook | Excel Worksheet Functions | |||
Calling macros from another XL Workbook | Excel Programming | |||
Calling macros in another spreadsheet | Excel Programming |