David,

Thank you for the response.

I am simply trying to execute a block of code (some several hundred
cells in a worksheet) multiple times, based on a changing parameter, and
record the corresponding results.

The parameters are listed in a column several thousand rows long (say A1
through A9999). I wish to record the rseults relationg to each parameter
in the adjacent adjacent column (say B1 through B9999). I am then
graphing the results.

I have currently duplicated the block of code in the several hundred
cells (a financial model) as many times as I have parameters. This has
limited the number of parameters and created a workbook 110MB+ in size,
which is unworkable.

I assumed that this could be solved by using a macro, so progressively
work down the list of parameters, perform the calculation, and record
the results.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!