.Find doesn't find matching cell value in first cell of range

[Prevost]

Hi There. I am using the .find function to find a value in a range (single column) and return the row number where that value first occurs. When my range is Cells(2,1) to Cells(40,1) and my value that I am trying to find is in Cell(2,1) (the value is actually in first 10 cells) the message box returns 3, not 2. Is this something inherent to Excel's find function, that it will not find the a matching value if it is in the first cell of a range or (more likely) what am i doing wrong? Thanks!

Sub testyme()

    Dim findtest As Range
    
        Set findtest = Range(Cells(2, 1), Cells(40, 1)).Find(what:="8E00002", lookat:=xlWhole)
        MsgBox (findtest.Row)

End Sub

 

[NeonRedSharpie]

The cell after which you want the search to begin. This corresponds to the position of the active cell when a search is done from the user interface. Notice that After must be a single cell in the range. Remember that the search begins after this cell; the specified cell isn’t searched until the method wraps back around to this cell. If you do no specify this argument, the search starts after the cell in the upper-left corner of the range.

There is an after argument that is optional.

[COLOR=#454545][FONT=Segoe UI].[/FONT][/COLOR][COLOR=#454545][FONT=Segoe UI]Find[/FONT][/COLOR][COLOR=#454545][FONT=Segoe UI]([/FONT][/COLOR][B][I]What[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]After[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]LookIn[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]LookAt[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]SearchOrder[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]SearchDirection[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]MatchCase[/I][/B][COLOR=#454545][FONT=Segoe UI], [/FONT][/COLOR][B][I]MatchByte[/I][/B][COLOR=#454545][FONT=Segoe UI],[/FONT][/COLOR][B][I]SearchFormat[/I][/B][COLOR=#454545][FONT=Segoe UI])[/FONT][/COLOR]

 

[Prevost]

Thanks. Then how do you start searching at the top left cell of the range? It says if it's omitted, the search begins after the cell in the top left corner, but if you specify a cell in the range, it starts after that cell. Do you have to specify the last cell in the range?