I am trying to do data validation in Excel and I've done it before but for some reason now this error is showing up. This is the error image

Here is the source table for it Source table

How can I fix this?

CodePudding user response：

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

Hope it's helpful

Range("A1:C10") Invalid

CodePudding user response：

When using "Lists" for data validation in excel spreadsheets, you must specify a range either horizontal (A1:J1) or vertical (A1:A10). This means you are not will be able to specify a "Matrix range" (A1:J10), and that is why the warning message says: "The list must refer to a single row or column (no a matrix).

Example of a wrong range selection: Example of a wrong range selection

Example of a correct range selection: Example of a correct range selection