Which Cell Does A Comment Belong To ?

[Jaafar Tribak]

You can easily to retrieve the comment in a cell but I am looking for the reverse

Sub Example()

    Dim oComment As Comment
    
    Set oComment = ActiveSheet.Comments(1)
    
    MsgBox Not (oComment Is Nothing) ' <== TRUE proves oComment variable holds a pointer to the comment object.
    
    MsgBox "Here I want to return the address of the cell that has the comment stored in the oComment Var."


End Sub

Any thoughts ?

 

[Fluff]

How about

   MsgBox oComment.Parent.Address

 

[Jaafar Tribak]

How about

   MsgBox oComment.Parent.Address

I swear the first intuitive thing I checked was the Parent object and somehow I got the worksheet instead of the range !!!!!

I must have done something weird .

Anyway, Thanks a lot for answering Fluff.

 

[Fluff]

You're welcome & thanks for the feedback