Thread: How do I reference the comments of a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default How do I reference the comments of a cell?
dim sText as string
sText=Range("A1").Comment.Text

HTH
--
AP

"BrotherSun" a écrit dans le message
de news: ...
Can I reference the comments of a cell in a formula?

For example, in cell B1, I want to type something like =A1.Comment


Reply With QuoteReply With Quote