How to get the Row object containing text found by Find?

[stormy]

I perform a .Find, either from a Range or Selection, and find text within a
table. I need to reference the entire Row object containing the Cell which
contains the text just found. I can get the entire Table, but I cannot find
a way to get just the Row.

Thanks
J

 

[Jean-Guy Marcil]

I perform a .Find, either from a Range or Selection, and find text within a
table. I need to reference the entire Row object containing the Cell which
contains the text just found. I can get the entire Table, but I cannot find
a way to get just the Row.

You probably get to the Table by doing something like:
expression.Tables(1)
where "expression" is the Range or Selection object of the found text.

Do the same with rows:
expression.Rows(1)

But, if there are vertically megrd cells, this will trigger an error... When
there are merged cells, you can only iterate the Cells collection of a Range
or Selection object, not the Rows or Columns one.

 

[stormy]

Jean-Guy,

Thank you! I never thought to try exp.Rows(1) without a table. It works
perfectly.