Is there a way to display the comment, attached to a cell, as the
'value' of the cell?

I have copied/pasted the comments to a new form (sheet) and would like
to have the comment text displayed IN the new cell. Then I can print
the sheet.

My current macro copies all comments from one sheet and pastes them
onto a second sheet. Now the new sheet shows the comment indicator,
with a blank cell. I want to replace the blank cell, with the TEXT of
the comment. Can this be done?

Thank you in advance.

JO