| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Re : Excel In Search of a Certain Comment
Joel & Peter T, Esq.,
Both of you are correct indeed. Regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Excel comment on mouseover but not the comment indicator | Excel Programming | |||
| Transfer Comment to VLOOKUP Cell on Search | Excel Discussion (Misc queries) | |||
| How do I remove the red corner in excel comment and keep comment? | Excel Programming | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
| Search Comment Text | Excel Programming | |||
Linear Mode
