Display formulas to print?

[Guest]

Hello,
I have a large amount of cells with formulas. They are all the same,
differing only in the cell references they contain. Is there a way to print
out or display these formulas for QC? I'd like to see a column(s) of these
formulas.

It would be so easy to qc that way.

Thanks!
Ellen

 

[Guest]

You can easily display formulas instead of the values they produce by pressing
CTRL + ` (The ` is below the ESC key)

Mike

 

[Prov31]

You can easily display formulas instead of the values they produce by pressing
CTRL + ` (The ` is below the ESC key)

Mike







- Show quoted text -

You can use this macro to print the formulas:
'Prints out formula as text
Function PF(Rng As Range) As String
Application.Volatile True
PF = Application.Text(Rng.FormulaLocal, "")
End Function


to print the formulas, just use the command =pf(cell ref).

Enjoy it.

 

[Guest]

Thanks, Mike!! It worked beautifully.

Prov 31: I think I need a bit more coaching on how to use macros, but
thanks for your response.

Ellen