Hi there,

I have a data validation list based on the value of a cell. I used the indirect formula, so every the value in this cell is changes the dependent one refers to a new named range (which I can choose from in the drop down list). I want my dependent list to be reset to blank (or better even to a default value "select"), every time the value in the main cell is changed.

I found code that works fine if I have a main and dependent list but since my "main" cell has simply a value and is not a data validation list, the code does not work.

B3 -parent cell (value change controlled by a combo-box (linked cell))

A13-A21 contain data validation list based on the value in B3 (list => indirect($B$3))


Anyone has a solution?

Thanks