reading comments value into a string variable

[Matilda]

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



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

[Matilda]

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
>