Thanks for the responses, but both replies override the computation in
C1. To clarify: I am trying to do a virtual array without physically
changing the table. C1 should always equal A1+B1, it's just that I am
trying to temporarily plug a different value in A1 and find out
temporarily what C1 would compute. I have a sheet that has over 30,000
programed cells and I do not want to write parrelel pages to run this
rather simple type of equation.


--
xcelentform
------------------------------------------------------------------------
xcelentform's Profile: http://www.excelforum.com/member.php...o&userid=16889
View this thread: http://www.excelforum.com/showthread...hreadid=504168