Recurrent Match Formula to Locate Multiple Instance of a String and Return Row Number

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:

Please Login or Register  to view this content.

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.