View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Mansfield[_2_] John Mansfield[_2_] is offline
external usenet poster
 
Posts: 15
Default Extract Cell Comments?

Yes, try

Range("A2").Value = Range("A1").Comment.Text

where range A1 contains your comment and range A2 is the
cell where you want the comment to appear as text.

John Mansfield
The Planning Deskbook
http://www.pdbook.com

-----Original Message-----
Can I systematically extract text from cell comments and
paste them into an adjacent cell?
.