comments in excel

[EGYPTIAN SUE]

How can I copy / cut & paste a table including all the formatting into a
comment in an excel spreadsheet

[Gordon]

"EGYPTIAN SUE" <EGYPTIAN [email protected]> wrote in message
news:[email protected]...
> How can I copy / cut & paste a table including all the formatting into a
> comment in an excel spreadsheet

A "comment" is designed for a brief note, to add some information about the
contents of a cell, and is plain text only AFAIK. What EXACTLY are you
trying to acheive?

[R.VENKATARAMAN]

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 [email protected]> wrote in message
news:[email protected]...
> How can I copy / cut & paste a table including all the formatting into a
> comment in an excel spreadsheet