View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Garrard Neil Garrard is offline
external usenet poster
 
Posts: 2
Default VBA and comments in Excel2002

Hello,

I want to combine comments from two cells and put the combined comment back
into one of the cells.

Writing the comment text back is easy enough with "[range].comment.text",
but how do you read the text from a comment associated with a particular
cell? It appears that the only way to do it is via
"[range].comment.shape.anternativetext". Does anyone have any ideas, sneaky
routines, etc for excel2002?

Thanks in advance,

Neil