I have used Excel for many years to produce repetitive structural calculations which help speed up the design process (Steel Beam Design, Load Take Down for Masonry Walls, Brick Retaining Walls etc). They do not have to be complicated and you do not have to use VBA to start with but if you...
A small modification makes the result dynamic and units can be added.
Sub ConvertFormulaToText()
Dim intRow As Integer
Dim intCol As Integer
Dim intCountRow As Integer
Dim strFormula As String
Dim myRange As Range
Dim strVal As String
Dim strText As String
Dim...
