Syntax to find the row num of a range of strings

i am trying to find the row num of a range of strings

i have tried FIND

Please Login or Register  to view this content.

i have tried MATCH

Please Login or Register  to view this content.

can someone tell me what i am doing wrong?

than_gold, that doesn't work as the line in my code fails on frow so trying to find frow.row will not work. i need the match line to evaluate to frow.

so can someone write me code as a test?

i will open up only one workbook
i will only use sheet1
in column A1 is "Apple", A2 is "Orange", and A3 is "Banana"

how can i search for Banana and have it return row 3 as a result. can someone please do that for me?

ok, so your code works. but when i put it in my workbook, it fails with the same object message.

here is my code.

Please Login or Register  to view this content.

it errors out on FindRowNumber so let me upload it and see if you can get it working.

so to display hdn_Codes worksheet, goto Mainsheet, select unhide button, type in "master" and then "Password", note that the P is caps. this will display the hdn_Codes table (which is on codesheet sheet1).

You get the error because "Bangalore" does not exist in A1:A4
Try

Please Login or Register  to view this content.

Fluff, your the king. very embarassed that i did not catch this till you pointed it out. by changing the range from a1:a4 to a2:a5 fixed the issue. minus one point for me.

thanks again.

You're welcome & thanks for the feedback