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...
I don't know if anyone will find this useful but I recently had to clean some data of misspellings before I could use it with VLOOKUP. I found some VBA that highlighted the misspellings but nothing to extract the actual words. Eventually with some prompts I wrote the following:-
Sub...
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...
