Error & Warning : "Unable to find values for validation in 'Sheet_Name'" How can I find the column that is missing the associated data validation list. (WARNING EMPTY ENUM)

[kg_fonkey]

Error & Warning : “Unable to find values for validation in ‘Sheet_Name’” (WARNING EMPTY ENUM)

Purpose: To find the column that is missing the associated data validation list.

Problem: The Error & Warning does not tell me which column is missing the data. I have hundreds of columns.

I assume there is no solution for this. I just wait until luckily find the column.
Thank you for reading.