Hi Mark,

Thank you for your attention on this issue.
At this time we are going to hold off with further development.

Leo

"Mark" wrote:

Well, I did'nt design this to work with more than one cell for each
named Range. If you want to get rid of the MsgBox then just comment
out the Msgbox line in the IssueWarning routine.
Sorry I didn't understand that QTY and AUDIT were supposed to be
something other than a single cell on a worksheet. I tried to work with
many different values in the cells before I sent it to you and I had no
problems. I can only surmise that the reason for the problem is
related to the code recieving conflicting calls for the same Range. I
would be happy to try and refine this to work for your SPECIFIC use,
but you will have to give me an ACCURATE description of your needs.
Other wise I am wasting time building the WRONG TOOL. Lemme know if
you are interested.