reading comments value into a string variable

[Guest]

Can't find anywhere the syntax for reading a comment into a variable in order
to write it to another cell.
cmnt = ActiveCell.comment.Text
produces error msg
- object variable orWith block not set

Many TIA'S in advance

Matilda

 

[Dave Peterson]

Check for a comment first.

if activecell.comment is nothing then
'do nothing
'cmnt = ""
'whatever you want
else
cmnt = activecell.comment.text
end if

 

[Guest]

Thanks for coming to the rescue again, Dave

Matilda x