Retrieving Text from Cell Comments

[tbrown]

Does anyone know how to capture the text in the cell
Comments to a file? There is no need to retain reference
to cells. Comments cell contain POC info that I want to
capture without copying and pasting each comment.
Appreciate any suggestions.
Terry

 

[Jason Morin]

You have a couple of options. One is to go to File > Page
Set-Up > Sheet tab and click on the "comments" drop-down
arrow and select "At end of sheet".

Or you can implement some code to print. Here are some
options from MVP David McRitichie:

http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH
Jason
Atlanta, GA

 

[Jim Rech]

Harald Staff posted this macro a while back that may help you:

Sub ListThem()
Dim C As Comment
Dim L As Long
L = 1
For Each C In Sheets(1).Comments
Sheets(2).Cells(L, 1).Value = C.Parent.Address
Sheets(2).Cells(L, 2).Value = C.Text
Sheets(2).Cells(L, 3).Value = C.Author
L = L + 1
Next
End Sub

Adjust the Sheets references as needed.

 

[Debra Dalgleish]

There are some techniques here for extracting text from comments:

http://www.contextures.com/xlcomments03.html

 

[Guest]

thanks for the feedback. I will give it a try.
Terry

 

[Terry]

Thanks so much. The link below work great!
Terry

http://www.mvps.org/dmcritchie/excel/ccomment.htm