B Bernard Liengme Aug 17, 2007 #2 My favourite way is with Chip's macro: http://www.cpearson.com/Excel/excelM.htm#PrintFormulas Need help with VBA? See David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes
My favourite way is with Chip's macro: http://www.cpearson.com/Excel/excelM.htm#PrintFormulas Need help with VBA? See David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes
G Guest Aug 18, 2007 #3 is there an eaiser way? Bernard Liengme said: My favourite way is with Chip's macro: http://www.cpearson.com/Excel/excelM.htm#PrintFormulas Need help with VBA? See David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email Click to expand...
is there an eaiser way? Bernard Liengme said: My favourite way is with Chip's macro: http://www.cpearson.com/Excel/excelM.htm#PrintFormulas Need help with VBA? See David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email Click to expand...
G Gord Dibben Aug 18, 2007 #4 No. Chip's macro would be quite easy. If you mean "without using VBA" there is a method but not very easy. Make a copy of your worksheet then Hit CTRL + `(backquote above Tab key) This will put you into View Formulas. Now F5>Special>Constants>OK Edit>Clear>Contents Print the sheet Do this for each sheet. Gord Dibben MS Excel MVP
No. Chip's macro would be quite easy. If you mean "without using VBA" there is a method but not very easy. Make a copy of your worksheet then Hit CTRL + `(backquote above Tab key) This will put you into View Formulas. Now F5>Special>Constants>OK Edit>Clear>Contents Print the sheet Do this for each sheet. Gord Dibben MS Excel MVP
