Display formulas to print?

E

EllenM

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
 
M

Mike

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

Mike
 
P

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 -
Click to expand...

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.
 
E

EllenM

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
 
Top