Display formulas to print?
 

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

Display formulas to print?
 

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

Mike

"EllenM" wrote:

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

Display formulas to print?
 

On Mar 2, 9:36 pm, Mike wrote:
You can easily display formulas instead of the values they produce by pressing
CTRL + ` (The ` is below the ESC key)

Mike



"EllenM" wrote:
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- Hide quoted text -

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

Display formulas to print?
 

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

"Mike" wrote:

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

Mike

"EllenM" wrote:

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