Obect Variable not set error; variable already defined?

**mrbusto71** · 10-05-2016, 06:03 PM

Hey folks! I have a weird little hangup here. Here's the code I'm using that I obtained from someone on the forums last month:

Please Login or Register  to view this content.

This thing flies until it hits this section towards the very bottom:

Please Login or Register  to view this content.

For some reason, it gives me "Error 91: Object variable or With block variable not set" on the .Cells.Find line. I'm assuming it has something to do with the sn variable, but it's already declared earlier in the code. Any ideas on what I'm missing? I tried moving the line into different areas, doing the unprotect sheet portion at different phases, and re-declaring the variable, but no luck.

Any help would be stellar! Thanks

**shg** · 10-05-2016, 06:27 PM

It means the value was not found, so the Find returns Nothing, and you can't refer to the Offset property of Nothing.

As a matter of practice, you should always test the return value of a Find, and not assume it always finds something.