Concatenating Cell COmments
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) |
Concatenating Cell COmments
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! |
Concatenating Cell COmments
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! |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com