We have an order form that we use for our clients, and their billing requires a unique VON number for each Manufacturer order. The form is constantly changing, and I have used Named Ranges such as "VON_Almark", "VON_DavdisonsEggs", ETC. What is the "softest code possible" that will look at all VON cells and make sure they do the following:
1) Has to be 10 digits
2) Only has to have a VON if the Cost is completed (named ranges of COST_ManufacturerName)
3) Cannot reuse a VON number on the form.