Quote Originally Posted by p45cal View Post
Paul, I wasn't talking about your code, but Ray707's! Although I can see I didn't make it crystal clear my mentioning 'it used to work' may have been a pointer.
1. I'm not sensitive -- any 'pride of authorship' I ever had was burned out of me decades ago

2. However, I did add some data protection to the macro for Ray707

I'd still use a list of Client Names in A1 with Data Validation