Run-time error '91': Object variable or With block variable not set

This is very helpful. This essentially is what I started out doing, only with find & vlookup. Wasn't sure of syntax.

Some more information - The 'products' range will vary in length with each use. This entire macro is part of a much larger & more complex task. My orig attempt was to define 2 ranges (the products one, and the 21 I need to look for) and to use your approach to look for the products in the 21, rather than the 21 in the products.

With your help, I am very close. I have two remaining tasks (1 for sure, 1 'nice to have')

Need for sure: have this sub-task loop through the entire 'products' list for any run it encounters (max # products is more like 350. My orig 50 was to get the code right. My current 500 is where I want to set it).

Nice to have: when sub-task reaches end of products list (as indicated by null cell in products range) to not continue until row 500.

I am attaching my updated doc. I have done nothing to the macro previously supplied. I have added a second tab - SYSTABLES. This mirrors the full task.

Using your modification, I now have the following:

Please Login or Register  to view this content.

Note: I have removed all reference to the 'products' range. Suffice it to say, it = ("B13:B500").

Might you be able to suggest anything? Thanks again!