Copy a comment to another cell - How?

[Dennis Macdonald]

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.

 

[Ryan Poth]

Dennis,

Try

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

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

Hope this helps,
Ryan

 

[Dennis Macdonald]

Thanks - perfect.

Dennis,

Try

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

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

Hope this helps,
Ryan