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????)

Paul Calcagno wrote:

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.

--

Dave Peterson

I looked at xl2007:

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

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


Paul Calcagno wrote:

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.

--

Dave Peterson

Code:
--------------------

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

End Sub

--------------------



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode

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.
"Dave Peterson" wrote in message
...
I looked at xl2007:

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

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


Paul Calcagno wrote:

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.

--

Dave Peterson

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



Paul Calcagno wrote:

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.
"Dave Peterson" wrote in message
...
I looked at xl2007:

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

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


Paul Calcagno wrote:

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.

--

Dave Peterson

--

Dave Peterson

Got it and it works fine. Thanks for the assistance...........Paul C.
"Dave Peterson" wrote in message
...
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



Paul Calcagno wrote:

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.
"Dave Peterson" wrote in message
...
I looked at xl2007:

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

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


Paul Calcagno wrote:

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.

--

Dave Peterson

--

Dave Peterson