The compiler bypass some value, when tring to use find function

I have the following code:

Please Login or Register  to view this content.

The problem is that when the value is: 1, 11, or 4, the compiler bypass that field. It is ok with other value upto 13. I guess there should be better phrase that will help me avoid that conflict other than this phrase: Sheet2.Range("A" & i)
Can anyone help me comeover this issue?

The full code:

Please Login or Register  to view this content.

Without seeing it in context, i.e. a sample workbook so we can what all the values are, it's difficult to say, but does this help at all?

Please Login or Register  to view this content.

Beth.

Originally Posted by BanginMyHeadOnMyDesk

Without seeing it in context, i.e. a sample workbook so we can what all the values are, it's difficult to say, but does this help at all?

Please Login or Register  to view this content.

Beth.

That's solved my problem.
Thanks a lot