Copying cell comments to another worksheet

[Barb Reinhardt]

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

 

[Tom Ogilvy]

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

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

 

[Barb Reinhardt]

Thanks so much. That gets what I need.

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

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

 

[Ron de Bruin]

See Dave's macro to copy to a Sheet
http://www.contextures.com/xlcomments03.html#CopyToSheet