VBA - To find the word 'Numeric' in merged cells

[gan_xl]

Hi Team,

Please have a look at the attached file.
In this, I need to find the word 'numeric' in the merged cells of first row (always first row) and to select its corresponding 2nd row data using macro.

In the attached file, M2 to P2 data to be selected.

Kindly help plz.


Thanks

[nilem]

try

Please Login or Register  to view this content.

[gan_xl]

Thanks Nilem. It works great.

[Mumps1]

What do you want to do with the second row data once you select it? There are two occurrences of "Numeric" in the first row. Do you want to find only the first occurrence or both?