Hi Dominic,

Checking the forum in which you made your post, I see that the prepended
dots were indeed included.

Using my newsreader to download messages from the MS public NGs, the dots do
not appear in your message.

My sincere apologies for doubting! .


---
Regards,
Norman



"dominicb" wrote in
message ...

Norman

On my system I can see the dots in front of the AddComment and
Comment.Text. - I still see them now in this copied quote. In fact
when I tested this piece of code I copied it straight from my posting
to the VBE within Excel 2000 and 2003 without a problem.

Regards

DominicB

dominicb Wrote:
Good afternoon Ajocios

You can only do this via VBA - a macro. The code below will copy the
contents of cell A1 into a comment contained in the currently active
cell.

Sub Macro1()
a = Range("A1").Value
usrcell = ActiveWindow.RangeSelection.Address
With Range(usrcell)
.AddComment
.Comment.Text Text:=a
End With
End Sub

Post back if you want any further help in implementing this.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=391261