Re : Excel In Search of a Certain Comment
 

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.

Re : Excel In Search of a Certain Comment
 

use set anchorcell = c.parent

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

" wrote:

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.

Re : Excel In Search of a Certain Comment
 

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.

Re : Excel In Search of a Certain Comment
 

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

Re : Excel In Search of a Certain Comment
 

Peter T Esq.,

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

Regards.

Re : Excel In Search of a Certain Comment
 

Joel & Peter T, Esq.,

Both of you are correct indeed. Regards.