Is it possible to concatenate cell comments. I need to sum up different
reports all in the same format but with different comment cell contents. When
I sum up the subtotals for the series of sheets I'd like to bring in the cell
comments as well. FOr example;
Name Age Hair Fingers
===================
Jeff 23 Brn 4(Note)
Bob 44 Brn 5
Sue 15 Blnd 3(Note)
_________________________
Total 12(Note, Note)

how about this?
Dim sComment As String
For Each c In ActiveSheet.Comments
sComment = sComment & " " & c.Text
Next
Range("A11").AddComment.Text sComment



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Do you know how to translate the VB code to C#?

"Claud Balls" wrote in message
...
how about this?
Dim sComment As String
For Each c In ActiveSheet.Comments
sComment = sComment & " " & c.Text
Next
Range("A11").AddComment.Text sComment



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!