Code for Multiple Named Ranges for Data Validation

TigerAvatar,

Got it.

Incidentally, in the Test3 file posted earlier, I put =Now() (to force a recalculation) in one of the cells. I closed the workbook and then reopened it. The whole thing was flickering and I had to CTRL-ALT-DEL to get it to stop.

So, I put a button on it. It is an extra step the user has to do, but they still don't have to manually enter names in that cell.

If you don't see a better way to go, I think this thread is solved.

Thanks for your help!

Respectfully,

Lost