Error message on macro

**zmbd** · 08-10-2011, 04:26 PM

I've attached a workbook with a macro that seems to be working as it is supposed to, however, every time I run it, an error message pops up and I don't know what to do to fix it. The error message is -
Run-time error '91':
Object variable or With block variable not set

Anyone know what I need to do to fix?

By the way, I'm not real adept at macros so you will probably be way over my head if you get too technical with your guidance (the awesome Leith Ross wrote the macro seen here).

Thanks!!!

**Bob Phillips** · 08-10-2011, 05:52 PM

Please Login or Register  to view this content.

**zmbd** · 08-10-2011, 06:29 PM

Man, you folks are good. This stuff looks like Greek to me. It seems to be working perfectly now.

**Bob Phillips** · 08-11-2011, 04:24 AM

The problem was caused by an empty sheet, so the word Partner got added to the check list (which should have been just initials). I just added a check that the last row of the search range was greater than the row 9 (your start point), therefore avoiding that situation. The rest is pure Leith