I have a button on a toobar that pastes the comments in using this code

Private Sub PasteComments()

Selection.PasteSpecial Paste:=xlPasteComments, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sunrosejenn" wrote in message
...
I'm trying to inert comments into a spreadsheet. Sometimes I need to
duplicate what is in one comment box into another. Is there a way to copy
and paste when inserting comments?

Excel 2003 is the version I am using

Thanks
Jeannette