Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using Linest for non-linear curve fitting, examples, hints and warnings
- The angle between two vectors, Python version
- Taming Symbols in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Elastic Biaxial Bend… on Biaxial bending update Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel Kapt Blasto on mpmath for Excel mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach David Graves on About Newton Excel Bach
Tag Archives: display formula reference values
UDF to replace cell references with values
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 display formula reference values, Evaluate text, Excel, UDF, VBA
Leave a comment
Showing numerical values of formulae cell references
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 .precedents, display formula reference values, Exce, GetRefs, VBA
9 Comments