searching for comments in just one column 1

[Luis939]

vb doesnt seem to allow me to search for comments in individual columns, only on the entire worksheet
is there anyway where i can essentially write

for each cmt in [A:A].comments
...
next

 

[SkipVought]

Luis,
If you check the properties of a Comment, position is not one of them. But Parent give you the range object

    For Each com In Comments
        If com.Parent.Column = 3 Then
        'stuff to do wint comments in col C
        End If
    Next

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Luis939]

oh i never thought about that, thanks

 

[Luis939]

just one more thing, it seems to me that it traverses the comments by row, at least i think it looks that way when i said

msgbox comment.text

would there be a way to make it traverse by column instead, thanks!!

 

[SkipVought]

Comments is a Collection associated with a Sheet (hence, the Parent Property). There is no DIRECT association with rows and columns.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884