Defined a range
 

Hi!
I have a macro which evaluate factors by selecting a range and execute a
macro A. The macro use the selected range and look at the left cell's of each
selected cell's to find the paramaters.

example:
Cells(1,1) = "=PrepareAPX("abc","0.07",3,50") 'Parameters
cells(1,2) = selected cell's = macro A put the resulting factor in this
cell. 'Results

Inside macro A, the factors are evaluate into an other program using an apx.
There's a limitation of 150 factors that can be evaluate at the same time.
I'm wondering if there's a way to select a big range and evaluate the factors
according to macro B that will split the range into 150 cell's range and
execute macroA 67 times? Also, is there a way to remove the selected cell's
that doesn't have "=PrepareAPX" inside the left cell's?

Thank you!
Alex




Since the macro run an OLe
--
Alex St-Pierre