Named range flaw?

[tiredofit]

In my worksheet, cell A1 takes its values from a list. This list is the range D1:D5.

Suppose I type the values 1 to 5 in cells D1 to D5. Then the user can only choose one of those values. in cell A1. If the user chooses to type some other value, it will be rejected.

If cells D1 to D5 are all blank cells, the user can only choose blank in cell A1. Again, trying to type any other value will be rejected. This makes sense.

What I have discovered is the following:

If cells D1 to D5 were named, say MyList and cell A1 contained Data Validation, =MyList, then if cells D1 to D5 were all blank, the user CAN now type anything into cell A1 and it WILL be accepted.

Has anyone else experienced this odd behaviour?

 

[ZVI]

Hi,
Yes, it is as is
At least, you can unselect "Ignore blank" chekbox in Data Validation - Settings to dissmiss that difference.

 

[tiredofit]

Hi,
Yes, it is as is
At least, you can unselect "Ignore blank" chekbox in Data Validation - Settings to dissmiss that difference.

Thanks for your feedback.