View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Copying cell comments to another worksheet

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