Thank you Paul. Yes I also noticed that in Name Manager. Some of the named Ranges had the _ symbol at the end of the names so I simply deleted those and reconfigured the named range. And Yes I also screwed up the Indirect() within Data Validation. I was on this sort of logical roundabout that I couldn't get off. Maybe If I had simply walked away, cleared my mind and then come back to the issue I probably would have found it. I had a one way ticket to "Frustration Central"