.find Function Failing

[Centexcel]

Excel Forum,

I am searching for the row number of a cell in column A that contains a specific value. My code is returning errors and after researching the issue I am still at a loss. I have tried cutting and pasting other programmers' code into my worksheet but that still fails. Any help will be greatly appreciated.

Below is my code and attached is the spreadsheet I am searching in. The portion that is failing me is in bold.

Thank you for your help.

Please Login or Register  to view this content.

[HaHoBe]

Hi, Centexcel,

the bolded code alone works okay and displays Row 17.

No sheet named "12 mo inc det" in the attachment, no code either - so Iīm not sure why your code would raise an error if the requirement like appropriate sheet are met.

Ciao,
Holger

[Centexcel]

Holger,

Thank you for your reply. I run the code and it produces a msgbox "not found."

I cannot figure out why my code runs differently in different sheets. Any ideas? Thank you for your time.

[AB33]

This one works

Please Login or Register  to view this content.

[HaHoBe]

Hi, Centexcel,

I run the code and it produces a msgbox "not found."

I changed from Number to Number as Text with preceeding ' - found. I changed 4010 to be result of a formula - found.

Code for me is located in a standard module - where did you place your code?

Ciao,
Holger

[Centexcel]

Thank you so much!

What does the columns(1) do for the function? Does it point the find function to A:A and then .find executes?

Thanks again, you've made my day!

[Centexcel]

Holger, I put my code in a standard module.
Can you explain how you changed number to number as text in the code?

Thank you for all your help.

[AB33]

Yes
Range("A:A") is another option

[HaHoBe]

Hi, Centexcel,

Number as Text:

Please Login or Register  to view this content.

In the code you provided you select a sheet, do some Copy&Paste and then do the search - maybe thatīs the key to why you wonīt find the item on other sheets.

keyrange builds up the correct area: $A$1:$A$291 - one of the first checks I did on the code. No need to go for a full column there IMHO.

Ciao,
Holger