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

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

Right-click on the cell that has the comment box you wish to duplicate, then
select COPY from the drop down.........then Right-click on the cell you wish
to replicate the comment in and select PASTE SPECIAL, then select COMMENTS,
then OK then Left-click off to any other cell........

hth
Vaya con Dios,
Chuck, CABGx3



"sunrosejenn" wrote:

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

Copy = paste special = comments

"sunrosejenn" wrote:

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