"Debra Dalgleish" wrote in message
...

That should work. What result were you getting?


Apologies - it appears that the cell did not contain a comment.

Hence I was getting an 'Object variable or with block variable not
set' error.

Sorry.


However, when I tried to debug by using this:

Set myComment = Activecell.Comment

and then stepped into the code, and looked in the locals window, there
is no 'text' property shown for the comment (even when it does
actually exist and has text in it!)

Am I missing the point of the locals window?

Alan.


PS: I appreciate you have better things to do than 'teach' me VBA
coding - tell me to go read a book or play with the buses if you
like - your help today has been very much appreciated.