For an existing comment you must get the text, search and replace the author,
delete the comment and reinsert it with the updated text
..Author is a read only property
Author in the comment comes from Application.UserName
See Debra's article on 'Comments' at
http://www.contextures.com/xlcomments03.html
to learn all about comments programming.
"Myles" wrote:
Is there some way to set the Author of a comment on a specific cell? I've
tried using the .author but i'm guessing that's read only.
Thanks guys!