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 =---

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
=---