I would like to be able to reference both the contents of another cell
and the comments from that cell too. I want comments to be generated
where comments exist in the cell being referenced. I have
idadvertantly managed to get the comments from the donor cell to be
returned as values in the formula cell - but I want them to apear as
comments.

I have found some interesting stuff at David McRitchie's page
http://www.mvps.org/dmcritchie/excel/ccomment.htm but I don't think it
does what I need.

Any help would be appreciated. I am using '97.

Many thanks