Calling Macros from a list

[Anonymous]

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

 

[Tom Ogilvy]

For each cell in Range("A1:A10"
Application.Run Thisworkbook.Name & "!" & cell.value
Next

--
Regards,
Tom Ogilvy

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

=---