VBA Find() question

I'm trying to use the find function to make my macros easier to handle, but I don't know how to run through all instances of what I'm trying to find and then stop. Currently I just have my find function in an infinite loop and it stops when it runs into an error. This works well I guess, but I'd like to know how to stop after the last instance without error. Here's the code that I have been using:

Please Login or Register  to view this content.

I've done some searches and found some code that checks to see if the find function returns a range. I've tried this method, but because I know nothing about this language, I'm having a hard time figuring out where my code is messing up. Here's the code that I'm trying to code now:

Please Login or Register  to view this content.

The code I'm replacing with "'Unimportant code here" has been tested and works fine. The program runs into an error at "Set rFound = ...". Does anybody know what I'm doing wrong?

--dorky

The code that's there is important if it changes the contents of rFound to eliminate the left paren.

Moved to programming....

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

VBA Noob