I need to be able to combine (add) comments from numerous worksheets in a
summary worksheet. Cannot use SUM with comments (text) Any suggestions.

Thanks
Frank

"Beep Beep" <(E-Mail Removed)> wrote in message
news:71A7F16D-31F6-4B9B-A26B-(E-Mail Removed)...
>I need to be able to combine (add) comments from numerous worksheets in a
> summary worksheet. Cannot use SUM with comments (text) Any suggestions.
>
> Thanks
> Frank

Hi Frank

Convert the comment.text to a string
as in "AAA = cell.Comment.Text"

Then concatate the string into a second string variable

such as

"BBB = BBB & " " & AAA

Hope this helps

N10