Copying Comments

  • Thread starter Thread starter Paul Calcagno
  • Start date Start date
P

Paul Calcagno

Can someone tell me if there's a command to copy a Comment that's been
created for a cell in Excel (Office 2007). I can create, edit and delete one
but don't see any tools for copying a comment.
Thanks, in advance.............Paul C.
 
In xl2003 menus, it shows up under the Edit|Paste special dialog.

I'd look there first (Home tab|Clipboard group????)
 
I looked at xl2007:

Home tab|Clipboard group|paste icon|paste special|comments.

Or rightclick on the destination cell and choose paste special|comments.
 
Code
-------------------

Private Sub CommandButton1_Click()
'copy comment from A1 to B1
Sheet1.Range("B1").AddComment Sheet1.Range("A1").Comment.Text

End Sub
 
Sorry for the delay in getting back, but when I click on the paste icon in
Home Tab|Clipboard group|paste icon, the paste special icon is greyed out.
Same thing happens if I rightclick on the destination cell... I cannot chose
the paste special|comments feature since it's greyed out also. I must be
doing something wrong.
If I'm attempting to paste special shouldn't I have proceeded that with a
copy. Buy copy what?
Paul C.
 
Yes, you have to copy something first to be able to paste it.

You'll want to select the cell with the comment, then do the copy (ctrl-c or
rightclick|copy).

Then do the paste special|comments
 
Back
Top