Combine Comments
 

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

Combine Comments
 

"Beep Beep" wrote in message
...
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