Find After:= Activecell not working

[jblevins]

I had to replace "Activecell" with the code below, will someone please tell me why it didn't work and kept returning to the same row?

    With Workbooks(wbName).Sheets("Contacts")
        .Activate
        .Columns("A:BC").Find(What:=frmData.txtFindText.Value, After:=[B].Cells(ActiveCell.Row + 1, 1)[/B], LookIn:=xlFormulas, LookAt _
            :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate
    End With

 

[Jerry Sullivan]

When it wasn't working, what was your activecell's address, what is the row of the first match you were trying to find, and what was the row that it found instead?

 

[jblevins]

When it wasn't working, what was your activecell's address, what is the row of the first match you were trying to find, and what was the row that it found instead?

I have two rows that contain the same searched data. It stayed in the same cell until the search was activated twice and then it would move. If I change the search data, it would find it immediately and worked fine as long as there was only one row with the data. After changing the "After" it works fine.

 

[Jerry Sullivan]

I can't tell whether you still have the Original question of why it didn't work with ActiveCell.

 

[jblevins]

I can't tell whether you still have the Original question of why it didn't work with ActiveCell.

I have the issue fixed, but I do not know why I have the problem and that is the issue. I thought that if "After:=Activecell" was entered it would jump to the row following the current row.