ExcelBanter - Row from test value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Row from test value (https://www.excelbanter.com/excel-programming/317142-row-test-value.html)

Glen Mettler[_4_]

Row from test value

I need to capture the row of a selected text value. ie:
LM is the text value in A1 of sheet1
I need to lookup LM in column F of sheet2 and capture the row.

I need to do that with code. How can I do it?

Glen

All times are GMT +1. The time now is 12:41 AM.