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:
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.
Bookmarks