Printing Comments

[Don]

I have a user that approached me with an Excel question
that I am having a challenging time answering.

My user has a spreadsheet with comments in several cells
that they want to print at the end of the document. Ok...
very easy. What my user doesn't like however, is the
generic "A1" reference to each of the cells on the
comments page.....

I thought giving each cell a "name" (Insert... Name) would
solve the problem. Unfortunately, my efforts proved
futile. It still gives the generic reference of "A1,"
instead of the name of the range.

Is there any way to use named ranges in the comments page?

Thanks in advance for any insight.

Don

 

[Debra Dalgleish]

There's some sample code on my web site that will copy comments to
another worksheet, in a list that includes the cell's name:

http://www.contextures.com/xlcomments03.html#CopyToSheet

You could then print this page.

 

[Don]

Debra...

Perfect! Thank you!

-----Original Message-----
There's some sample code on my web site that will copy comments to
another worksheet, in a list that includes the cell's name:
http://www.contextures.com/xlcomments03.html#CopyToSheet

You could then print this page.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.