Can someone spot the obvious error? I've been looking at this for over an hour and can't see the problem.
In the above snippet, rngFind and rngSearch are both defined as Range objects and sNew is a string. The Find is successful; rngFind is populated with cell information. However, the Do Until line throws error '424', saying that an object is required. What is wrong with using a Range in this way?
Please Login or Register to view this content.