Forum Discussion
Excel Data Validation List Error
Hello, Last mont or so i created an excel with a data Validation like this:
=IF($C$2="DAM-1",'Hiden Data'!$B$2:$B$5,IF($C$2="DAM-2",'Hiden Data'!$B$6:$B$8,IF($C$2="DISCO FAN LEAP-A",'Hiden Data...
The data validation formula is valid!
Nothing wrong with it!
Read the error message well, it's straightforward!
It means that the data validation list must be a one-way list (single column range or single row range), or a delimited list like this: A, B, AB, CD.
Range("A1:A10") Valid
Range("A1:D1") Valid
Range("A1:C10") Invalid
Follow these conditions and you will get rid of that error message!
Hi Haytham,
As you can see in the code, all the options are in the same Coulmn (B).
The code worked properly before, but now it doesn´t, and that is exactly the proplem.
I only wanted to change one name option, but the error appeared. I canceled, opened again, and the data validation works, but if i open the data validation it will pop the error, even if i just opened and click acept without modifying anything.
And because i really need to modify it, its a problem.
As you can see in the code, all the options are in the same Coulmn (B).
The code worked properly before, but now it doesn´t, and that is exactly the proplem.
I only wanted to change one name option, but the error appeared. I canceled, opened again, and the data validation works, but if i open the data validation it will pop the error, even if i just opened and click acept without modifying anything.
And because i really need to modify it, its a problem.