How can I print the formulas in a worksheet?? Thanks,
D David McRitchie Oct 9, 2003 #3 If you mean how to show the formula used in another cell see the GetFormula macro in http://www.mvps.org/dmcritchie/excel/formula.htm other solutions are in the related area at the bottom of the page such as on John Walkenbach's pages. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
If you mean how to show the formula used in another cell see the GetFormula macro in http://www.mvps.org/dmcritchie/excel/formula.htm other solutions are in the related area at the bottom of the page such as on John Walkenbach's pages. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
T tel Oct 10, 2003 #4 Select Tools, Options and click the formulas box David McRitchie said: If you mean how to show the formula used in another cell see the GetFormula macro in http://www.mvps.org/dmcritchie/excel/formula.htm other solutions are in the related area at the bottom of the page such as on John Walkenbach's pages. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm Susan, here is one way, Ctrl+` Click to expand... Click to expand...
Select Tools, Options and click the formulas box David McRitchie said: If you mean how to show the formula used in another cell see the GetFormula macro in http://www.mvps.org/dmcritchie/excel/formula.htm other solutions are in the related area at the bottom of the page such as on John Walkenbach's pages. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm Susan, here is one way, Ctrl+` Click to expand... Click to expand...
