Earl
See John Walkenbach's site for his ListFormulas macro.
http://j-walk.com/ss/excel/tips/tip37.htm
"Most users have discovered that Excel has an option that lets you display
formulas directly in their cells: Choose Tools Options, click the View tab,
and select the Formulas checkbox. However, Excel doesn't provide a way to
generate a concise list of all formulas in a worksheet. The VBA macro below
inserts a new worksheet, then creates a list of all formulas, cell addresses
and their current values."
Gord Dibben Excel MVP
On Sun, 12 Dec 2004 20:05:04 -0800, "Earl"
wrote:
How do I print a list of all formulas contained in a worksheet?