Copy a comment to another cell - How?
 

I have a sheet with a number of comments. I need to be able, via vba
code, to copy these comments, with all their formats, but not the cell
contents itself, to another cell on another sheet (ie only the
comment).

How do I do this?

Thanks for your help,
Dennis.

Copy a comment to another cell - How?
 

Dennis,

Try

Range("B2").Copy
Range("B3").PasteSpecial Paste:=xlPasteComments

(using "B2" and "B3" as random examples)

Hope this helps,
Ryan


-----Original Message-----
I have a sheet with a number of comments. I need to be
able, via vba
code, to copy these comments, with all their formats, but
not the cell
contents itself, to another cell on another sheet (ie
only the
comment).

How do I do this?

Thanks for your help,
Dennis.
.

Copy a comment to another cell - How?
 

Thanks - perfect.


"Ryan Poth" wrote in message ...
Dennis,

Try

Range("B2").Copy
Range("B3").PasteSpecial Paste:=xlPasteComments

(using "B2" and "B3" as random examples)

Hope this helps,
Ryan


-----Original Message-----
I have a sheet with a number of comments. I need to be
able, via vba
code, to copy these comments, with all their formats, but
not the cell
contents itself, to another cell on another sheet (ie
only the
comment).

How do I do this?

Thanks for your help,
Dennis.
.