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