how to copy cell with remark

[moonhkt]

Hi All

How to copy cell with remark ?

Excel : 2003

moonhkt

 

[leung eric]

Hi All

How to copy cell with remark ?

Excel : 2003

moonhkt

More Infrormation. I open two instance of Excel.exe. For compare excel
side by side verify and copy.
The remark or comment can not copy between 2 excel instance.

When open 2 file in one Excel.exe, the comment can able to copy.

 

[GS]

After serious thinking leung eric wrote :

More Infrormation. I open two instance of Excel.exe. For compare excel
side by side verify and copy.
The remark or comment can not copy between 2 excel instance.

When open 2 file in one Excel.exe, the comment can able to copy.

That's because Comments are not copy-able between instances. If you
look at the object hierarchy for a Comment you'll see that its highest
level of scope is Excel instance containing the workbook it exists in.
It's parent is the Range it belongs to; the Range's parent is the
worksheet; ..and so on.

The only way to physically move a comment from one instance of Excel to
another is to programmatically grab the comment's 'Text' property and
populate a target range with a new comment that contains the text. That
won't copy any formatting unless you also do the same for its
'FillColor' and 'ForeColor' properties. In any respect you can't copy
any RTF formatting this way.

Otherwise, Excel seems to manage its own clipboard content internally
(per instance) for stuff like this. This is different that what we
expect from the Windows clipboard's normal behavior.

 

[moonhkt]

After serious thinking leung eric wrote :




That's because Comments are not copy-able between instances. If you
look at the object hierarchy for a Comment you'll see that its highest
level of scope is Excel instance containing the workbook it exists in.
It's parent is the Range it belongs to; the Range's parent is the
worksheet; ..and so on.

The only way to physically move a comment from one instance of Excel to
another is to programmatically grab the comment's 'Text' property and
populate a target range with a new comment that contains the text. That
won't copy any formatting unless you also do the same for its
'FillColor' and 'ForeColor' properties. In any respect you can't copy
any RTF formatting this way.

Otherwise, Excel seems to manage its own clipboard content internally
(per instance) for stuff like this. This is different that what we
expect from the Windows clipboard's normal behavior.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Thank for you advice.