Thread: Getting the FULL text of a Comment
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
  
Posts: 173
Default Getting the FULL text of a Comment
Phil,

Typically String variables are limited to 255 characters. If your macro is using the Comment text to feed a String variable, then this limit may be the culprit. Have you tried sending the Comment text to a cell? For example (assuming comment in cell A1 and text going to B1):

sheet1.Range("B1").Value = sheet1.Range("A1").Comment.Text
Reply With QuoteReply With Quote