View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anonymous[_3_] Anonymous[_3_] is offline
external usenet poster
 
Posts: 9
Default 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 =---