suppose you have entered some in cell D8 e.g. rv

you want this to be entered in comments of cell G10

try this url

Public Sub test()
Dim x As String
x = Range("d8").Value
Range("g10").AddComment x
End Sub
==========
see whether you get what you want.
perhaps itis not possible to copy the format etc.


EGYPTIAN SUE <EGYPTIAN wrote in message
...
How can I copy / cut & paste a table including all the formatting into a
comment in an excel spreadsheet