Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- ULS Design Functions 2.13
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: GetRefs
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