B2 is within the range of A1:C4... My question is are you wanting to capture
the value of B2 or the value that the formula is returning or ???. This can
be done but it will require some VBA code triggered from the calculate event
to copy the values over to the new table...
--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:

What does B2 have to do with, and how will the formula in question change
just because of a recalculate?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dave F" wrote in message
...
I have a formula which calculates different values every time the workbook
is
re-calculated, as this formula references a cell which uses the RAND()
function.

Is it possible to capture each value and have it be populated in a
separate
table?

I'm assuming that, if possible, this entails using a macro, however, if it
helps, here's the formula in question: =(SUM(D4:E4,A1:C4)*SUM(A1:E4))^D4

B2 contains the RAND() function.
--
Brevity is the soul of wit.