I want to see formulas with their results when I print.
Here's one way:
1. Enter a UDF (VBA routine)
<alt-F11> opens the VB Editor
Ensure your current project is highlighted in the Project Explorer
Insert/Module
Paste the code below into the window that opens:
Function ShowFormula(rg As Range) As String
ShowFormula = rg.Formula
End Function
2. You now have several methods of showing this formula:
Insert a column next to the column with your formula.
Assuming your formula is in Column C, place in Column D:
=C2 & ShowFormula(C2)
Copy down as needed.
For printing, hide column C.
You could also, in Column D, put the formula ShowFormula(C2) and print both
columns C & D.
--ron