View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BOHICA BOHICA is offline
external usenet poster
 
Posts: 18
Default Run Macro from another X number of times

okay then...I am looking for a way to make a macro that accesses
another macro as a sub routine according to a number in the selected
cell...

Example:
use active cell

run the following line (X)-1 times, X being the active cell value
Application.Run "'Data 10-25-03.xls'!NEWADDLOAD"

So, if the active cell has a value of 4, then the macro would execute
3 times the !NEWADDLOAD macro.

Okay, anyone have any ideas?

Thanks
-The Roach