View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ben McBen Ben McBen is offline
external usenet poster
 
Posts: 56
Default How to copy comments to cell as normal text?

Not sure if you are after a VBA solution:

Range("A1") = Range("B1").Comment.Text



"NPV" wrote:

How to copy comments to cell as normal text?