Search for specific word in column (2nd, 3rd time)

[adam18]

Question:

So basically I am trying to search in a certain column for the word "Work Type" but the problem is that the very first row in the column already has that word.

What I want to do is find the 2nd time in the same column (many rows down) that word is repeated.

I also need to be able to find the 3rd time the same word is repeated.

What I basically have is this:

Cells.Find(What:="Work Type", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _
x2Next, MatchCase:=False, SearchFormat:=False).Activate

but the problem is that it keeps jumping to the first time that word is shown.

Can anyone help me with this?
Thanks.

 

[C Moore]

I haven't tested anything, but instead of cells which looks at them all make it range($A:$A).find(...,after:=range("A2")...), should get you the first one, range($A:$A).findnext should go to the third one.