Problem when using Named Range instead of simple Range

Here is my code: The code for Supplier1: works great. The code for Supplier2: throws an error. However, I really prefer to use Defined Names over simple ranges. There are only 3 lines that are different between Supplier1: and Supplier2: They are as follows:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any help is greatly appreciated.

Please Login or Register  to view this content.

Product1 Defined Range:

Please Login or Register  to view this content.

PCost1 Defined Range:

Please Login or Register  to view this content.

Test Sheet

Yes. I need to find the first empty cell in Product1. I can make it work if Product1 is not empty. But if Product1 is empty i just get errors

Originally Posted by Norie

If Product1 is empty then it's likely that when you try and find the next empty row you'll end up in a row above the range Product1 refers to.

Why are you using the named ranges anyway?

Named Ranges allow me to insert columns without breaking the code for one