View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Redbeard Redbeard is offline
external usenet poster
 
Posts: 1
Default Procedure name as variable


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