Right, xld. I have deleted all named ranges that were sheet-specific. Apparently, ranges were copied, which brought over the named ranges. Then the "new" named range was deleted, which resulted in #REFs. I've created a DataSheet, where I've placed ALL the dropdown validation values. And at this rate, I am still probably only 10% into completely fixing this workbook. I'll put your macro in the workbook itself for the user to use later. Thanks!