VBA to search for cell and replace value

This is an extension of my post found here, but trying to approach the problem from a different perspective.
http://www.excelforum.com/showthread...t=#post4440273
Based on extensive internet searching and studying VBA (first venture into this world) I have found a code to find a value
But now I need to develop it in two big ways.
1) End result should be to replace the value with another value in a different cell, different column but same row (i.e.("f6").value replace with range("i6").value
2) As this record is repeating, it should loop through the search, redefining "i" and "findstring" and searching until "findstring"="" (i.e. search based on f6, after calculation is complete, search based on f16, f26, etc.)
The code, which I lightly modified, is as follows: (any advise for improving speed or reliability is appreciated. Total newb)

Please Login or Register  to view this content.

Moderation removed. Code Tags are added. Thank you, DaBrot791.

This is what I have so far. I've solved my problems... in the sense that I can do what I wanted. However, these records may accumulate to become upwards of 1500 entries.
Running a test now on only 12 inputs took aproximately 10 seconds to change all of them. Is there a faster way to write this?

Please Login or Register  to view this content.

Try the Code below, and see if it is faster.

Please Login or Register  to view this content.

Wow! that is tremendously faster! I eliminated the clause for findstringnext since that wasn't needed but changing those application settings made it incredibly fast! And it doesn't appear to negatively affect the rest of the worksheet!
Definitely solved the problem! Thanks a lot! Now I just have to understand what exactly those two values do.
The following code is just in case someone else is interested.

Please Login or Register  to view this content.

Hi DaBrot791,

Thank you for the feedback, and for adding to my Reputation. Much appreciated.

Glad I could help.

Regards.