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



Sam wrote:

Hi, I wonder if any one can help , I have a row of cells (a2-ab2)and each one
will have a comment placed in them using the insert a comment tool on the
tool bar, is there any way to collate them say in a new sheet or even into a
Microsoft word sheet, can it be done?.
Thanks in advance for any ideas.
Sam.

--

Dave Peterson