Thanks, both good ideas but unfortunately they won't work in this case.
The 'calculation' happens on a separate worksheet and contains many
steps (too many to occur in a single cell). It's esentially a
calculator to determine X based on A, B, C, D, E. Ideally it would be
an iterative process whereby the calculator in sheet1 one would look
at the values in sheet2 A1:E1 and put the result in F1, and then repeat
for A2:E2, etc. several hundreds or thousands of times.


--
Jetta1515
------------------------------------------------------------------------
Jetta1515's Profile: http://www.excelforum.com/member.php...o&userid=34982
View this thread: http://www.excelforum.com/showthread...hreadid=547207