Huh? How do come by 478232 as a cell reference number

or did you mean C8: 478232

File, Page Setup, Sheets,
[x] Row and Column Headings
Comments: At End of Sheet

If you want to tailor your own printout of cell comments see
http://www.mvps.org/dmcritchie/excel...m#printsastext

Macro to populate another sheet with comments by column (#printcommentsbycolumn)
http://www.mvps.org/dmcritchie/excel...mmentsbycolumn

"dickenswick" wrote ...
I would like to see a printout of my comments using the contents of the cells
I'm printing, not "Cell: c8" for example, but "Cell: 478232".