I'm looking at the possibility of using printed coments as a way of variance
reporting on worksheets with tables showing period end results. I'm using a
shared workbook which is updated by a group of users. Using the default
'print comments at end of sheet' uses the cell address as the pronted comment
header. It would be more informative if the header could be the cell
RangeName. Ability to add some standard text and also the cell value would be
useful too.
Any suggestions on how to achieve the above will be much appreciated
--
Thanks,
David

Hi David,
See http://www.mvps.org/dmcritchie/excel/ccomment.htm
and also the related area at the end.

You typically would show the cell address, value (.value), formatted value (.text),
formula and possibly the row 1 header, and the column A header on a row.
---
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

"David" wrote in message ...
I'm looking at the possibility of using printed coments as a way of variance
reporting on worksheets with tables showing period end results. I'm using a
shared workbook which is updated by a group of users. Using the default
'print comments at end of sheet' uses the cell address as the pronted comment
header. It would be more informative if the header could be the cell
RangeName. Ability to add some standard text and also the cell value would be
useful too.
Any suggestions on how to achieve the above will be much appreciated
--
Thanks,
David

Thanks David
--
David

You're welcome David.
---
David