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