Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- Frame Analysis with Excel 1 - Single beam
- The history of the theory of beam bending - Part 1
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Function roots with the Inverse Quadratic Method
- Contour plots with Excel and Matplotlib
- Frame Analysis with Excel - 4, 2D frame analysis
- Latex Maths Text in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
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