This system seems to work fine once, but it won't loop. Here is an
example of what I'm trying to do:
For A = 1 To 30
Macro(A) = ActiveCell.Value
ActiveCell.Offset(1, 0).Select
Next A
For A = 1 To 30
Application.Run Macro(A)
Next A
When I run this it goes fine the first time but then ends. Does it
have to wait for one to finish before it will run the next? If so, is
there a way to tell it to wait? I can insert a pause but that seem
clumsy.
Again, thanks for your help.
--
Redbeard
------------------------------------------------------------------------
Redbeard's Profile:
http://www.excelforum.com/member.php...o&userid=24612
View this thread:
http://www.excelforum.com/showthread...hreadid=536813