Print cell names and cell contents 1

[mohtogh]

Hi There,
How Can I print Cell names (e.g. A23) and Cell contents and cell formulas together?
E.g.
A23 14 -----
A24 Smith -----
A25 28 =A23^2
A25 7 =A23/2

Thanks

 

[joerd]

Not sure what you want to accomplish, but if you want to display the formula of a cell next to its result, you can look into the following threads:
Formula Display in Excel thread770-37797
Formulas in Cells?!?! thread770-42227
Another EXCEL FORMULA DISPLAY QUESTION thread770-41284
Display formula instead of formula result in Excel thread770-8148


Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[Gearhead]

Try Downloading the Add-In MathLook for Excel. There is a free trial at

http://www.uts.com

 

[mohtogh]

Thank you both.