Re : Excel In Search of a Certain Comment

T

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.
 
T

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.
 
P

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
 
T

tkt_tang

Peter T Esq.,

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

Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top