Hello,

earlier in Excel you were able to adress a comment (now known as note).

with Offfice 365 comes a new function: threaded comments.

to work with them is good and easy but I'm not able to adress them via VBA or to be more specific: to read them via VBA.

I only find - with help of the makro-recorder - the new name for it.
Range("E2").AddCommentThreaded ("this is a test")
Could someone help me to read the text of the treaded comments?


greets
Marc