reading comments value into a string variable
 

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

reading comments value into a string variable
 

Check for a comment first.

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



Matilda wrote:

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

reading comments value into a string variable
 

Thanks for coming to the rescue again, Dave

Matilda x
"Dave Peterson" wrote:

Check for a comment first.

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



Matilda wrote:

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