Thanks Norman. I'll bear this in mind, but Tom's solution worked so I'm
sticking with that for the moment.

"Norman Jones" wrote:

Hi Pete,

For an existing comment try:

Range("A1").Comment.Text _
"This is a comment in cell A1"


or to create the comment:

With ActiveSheet.Range("A1").AddComment
.Text "Howdy!"
End With

---
Regards,
Norman



"Pete at Sappi Fine Paper"
wrote in message ...
I should have thought that the command:

range("A1").comment = "This is a comment in cell A1"

would work ... but it doesn't. I get an error message which reads:

"Object variable or With block variable not set"

Can anyone help?