Run Time Error 91, Object Variable or With Block Variable not set

[undergraduate]

I have this macros below that keeps giving me a Run Time Error 91, Object Variable or With Block Variable not set prompt at the line that begins "Loop While". I was wondering if this can be fixed. This was a problem that arose from an existing thread, as its a new issue I am reposting. Thank You.

Please Login or Register  to view this content.

[StephenR]

Try changing that line to

Please Login or Register  to view this content.

[shg]

This line, which comes directly from Help, should NEVER be used:

Please Login or Register  to view this content.

If c is Nothing, then c.Address will error; and if c has an Address, it is not Nothing. (VBA always evaluates all arguments to a logical expression; if it paid attention to the And operator and quit after evaluating the first, it wouldn't be a problem)

If the search ultimately ends by finding the first entry again, then you should use

Please Login or Register  to view this content.

If it ends because you are destroying the found value, then use

Please Login or Register  to view this content.

If either could happen then

Please Login or Register  to view this content.

[undergraduate]

Thank you it worked great, I used the following code:

Please Login or Register  to view this content.