Re : Excel In Search of a Certain Comment

  • Thread starter Thread starter tkt_tang
  • Start date Start date
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.
 
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 Esq.,

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

Regards.
 
Back
Top