Tag Archives: display formula reference values

UDF to replace cell references with values

Posted on August 30, 2017 by dougaj4

I recently posted an update to the Eval2 spreadsheet with a subroutine to display a cell formula as a text string, with the cell references replaced by the associated values. I have now added three user defined functions (UDFs) to do … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | Leave a comment

Showing numerical values of formulae cell references

Posted on April 28, 2011 by dougaj4

This post follows from a discussion at Eng-Tips The original question was for a way of displaying the value of each component of an Excel formula.  It is easy to display the formula, rather than the result, for all the … Continue reading →

Posted in Excel, VBA | Tagged , , , , | 9 Comments