Comments, is there a way to export them?

[Mr BT]

Hi
Is there a way, formulae or vb, to copy the text from a comment (or many) to
a selected cell?
Thank you for the assistance

 

[Roger Govier]

Hi

take a look at Debra Dalgleish's site
http://www.contextures.com/xlcomments03.html#CopyToWord

If you scroll down the sheet, there is also code from Dave Peterson to copy
comments to another sheet in the workbook.