View Single Post
  #8   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Question On Excel Formulas

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