Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using RC Design Functions 4 - Umom and new MaxAx function
- Using LINEST for non-linear curve fitting
- Deflections and Moments in Rectangular Plates
- ULS design of reinforced concrete, AS, ACI and European codes
- Python and pyxll
- Using Array Formulas
- Stepping through 3DFrame
- More on RC design of circular sections
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 7: Lateraly loaded pile analysis
Recent Comments
Tag Archives: .precedents
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