View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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.