Runtime Error '424' - Object Required

Hi guys,

Can someone spot the obvious error? I've been looking at this for over an hour and can't see the problem.

Please Login or Register  to view this content.

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?

Hi Floyd,

Perhaps try "rngFind is Nothing" instead of "..is Empty".

I believe Empty refers to strings, while Nothing refers to objects (at a basic level).

D'OH! I'm such a klutz. Thank you!