Thanks so much. That gets what I need.

"Tom Ogilvy" wrote:

http://www.cpearson.com/excel/excelM.htm#PrintComments

might be a start. It writes to word instead of another worksheet.

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

I have been reviewing a huge workbook and have added a lot of cell comments.
Is there a way to display all of these on another worksheet? I'd need to
know the worksheetname, the cell location and the comment.

Thanks,
Barb Reinhardt