On Mon, 21 Nov 2005 09:41:12 -0500, "David Smith" wrote:


"Ron Rosenfeld" wrote in message
.. .
On Mon, 21 Nov 2005 08:48:23 -0500, "David Smith" wrote:

"Ron Rosenfeld" wrote in message
...
On Sun, 20 Nov 2005 12:17:28 -0500, "David Smith"
wrote:

Hello,

Is there a way (addin utilities or otherwise) to cause the formula in a
cell
to display the values for the component references making up the
formula?

-i.e =A1 *(B2+C4)/D2

would display based on the cell reference values as:

=5*(4+6)/8

Thanks for your help,

David S



I don't know if this will be helpful, but you could also set up a Watch
Window
and Watch the contents of the references.
--ron

Hi Ron,
I am not to famiiar with the visual basic editor. I can view the watch
window but how do I do what you suggest?

Thanks....

David S


This is an Excel feature, no VBA required.

View/Toolbars and select the Watch Window toolbar. You can then set a
Watch
for various cells.

This is different from the Watch window in VBA.


--ron

Hi Ron,

Tried that but it does not give me anything more than the value in the total
cell and its formula. I am interested in seeing the individual values of the
component parts of a formula as described in my original post. So I can do a
quick audit of the formula based on an assumption sheet or known values.

Thank you.....

David S


Oh. I thought you had tried the Evaluate Formula option suggested by Niek and
found it lacking. But that would be one thing to try.


--ron