Using macro to enter value in one cell from range of cells
Posted by JP on February 13, 2001 3:09 PM
I built a model that is driven by the value in one cell.
I have 200 values which I need to run the model from.
I would like to build a macro which takes the first of the 200
values, calculates the effect on the model, prints, and then moves
to the second of the 200 and performs the same steps, and continues
until all 200 values have been used. Can anyone help me?