Re : Excel In Search of a Certain Comment

[tkt_tang]

Set cmt = Worksheets(1).Comments

For Each c In cmt

<How Could One Locate the Anchor Cells for the Given Comments ?>

Next

Anchor cell for a comment is that range (located on an Excel
WorkSheet) at which the comment is added thus,

Range("A1").AddComment Text:=Txt & " new text"

Please share your experience.

Regards.

 

[Joel]

use set anchorcell = c.parent

or to get the address
anchoraddress = c.parent.address

 

[tkt_tang]

Joel, Esq.,

Thank you for your response to my query.

But, c.Parent refers to the WorkSheet on which the Comment is located.

Regards. TKT-Tang.

 

[Peter T]

But, c.Parent refers to the WorkSheet on which the Comment is located.

No, c.Parent is a range object, the cell the comment is anchored to.

Regards,
Peter T

 

[tkt_tang]

Peter T Esq.,

c.Parent.Name gives the Tag-Name of the WorkSheet on which the Comment
is located.

Regards.

 

[tkt_tang]

Joel & Peter T, Esq.,

Both of you are correct indeed. Regards.