Three questions about comments:
1. Within a loop such as this:
for each cmt in activesheet.comments
... how do I find out the cell in which cmt is?
next
2. Is there a way of finding out if a cell, say the Activecell, has a
comment?
3. The Author property of a comment is read only; is there a way of changing
it other than by deleting it and recreating it? (hence, question 1).
Thanks for your help.
Bookmarks