Display the fomula of one cell as the text string value of another cell? (2007)

[JayUSA]

Hello,

This is an oddball question, but here goes...

Can I program one cell to display the formula of another cell (as a text string)?

In other words, if the formula for A1 (as it appears in the formula bar) is:

=SUM(Table[Orders])

Can I program cell B1 to display "=SUM(Table[Orders])" as its cell value in the spreadsheet?

Cheers,

Jay

[shg]

Hit Ctrl+` to toggle between display of formulas and values.

Otherwise, VBA.