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