Aug 13 2020 11:20 AM
Aug 13 2020 12:56 PM - edited Aug 13 2020 12:59 PM
That would do it. If your version of Excel does not feature FORMULATEXT() you could emulate it with a UDF
Function showFormula(target As Range) As String showFormula = target.Formula End Function
The Formula property and its variants can also be set from VBA, allowing the worksheet to be built from code.