Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- The Ultimate Python Guide for VBA Developers
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
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