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.