Combine Comments

[Guest]

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

 

[N10]

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