Thread: copy comment content to cell content as data not as comment
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
  
Posts: 468
Default copy comment content to cell content as data not as comment
Say you have a comment in Cell C6 and A1 is your Target for the Comment text

Sub foo()
Range("A1").Value = Application.Range("C6").Comment.Text
End Sub

"Lilach" wrote:

How do I copy comment content to cell content as data and not as comment?
Reply With QuoteReply With Quote