Data validation without helper column

Hello to all,
I am uploading a file which is self-explanatory.
The data validation on the yellow cell contains the correct data but I need to achieve the same result without the usage of the Helper column.
Would this be possible?
Many thanks.
Octavio

you can use hardcoded delimited list, eg: Albania,Algeria, and so on

You are absolutely right. The problem is that I have to change a bunch of lines of VBA code just to accomodate this helper column. I would like to avoid it because I am changing the work of somebody else...and will have to dig a lot...
If there's no way...let me start digging..
Otavio

Yes, but the users can add or remove countries, so that solution will not work...
But thanks, anyway.
Octavio

Can someone please move this thread to VBA fórum?
I was thinking... Maybe the data can be stored in ano array, and use that array in the data validation source...

Thanks

Thanks, have to think on that.

Originally Posted by oteixeira

You are absolutely right. The problem is that I have to change a bunch of lines of VBA code just to accomodate this helper column. I would like to avoid it because I am changing the work of somebody else...and will have to dig a lot...
If there's no way...let me start digging..
Otavio

Why do you have to change code to accommodate a helper column? Make the helper column to the right of all your sheet data and you won't have to change the code.

Torachan, just what I was looking for!
Many thanks for your kind help and patience.
Octavio