I need to write a macro that will return the column number of n instances of a string. The idea is to find the first instance of a particular string, return its row number and modify something using that row number, then using a for next loop use that row number as the new starting point to find the next instance, etc.

Heres the code I have so far:
Sub Find()
Dim RowCount As Integer

RowCount = 0

For i = 1 To 5
RowCount = WorksheetFunction.Match("Hello", Range("A" & RowCount + 1 & ":A100"), 0)
Range("B" & RowCount) = "World"
Next i

End Sub

In this example I am finding every instance of Hello in Column A, the using the row number to modify the exact same row in Column B to say World. Then the for loop increments and the Match function starts from the row just below the previous instance of Hello.

I just can't seem to get this to work right.

Any help is greatly appreciated.