Data Validation - Drop-down Dependent List

Hello everyone,

I've been stuck on a Data validation list issue for 2 days and I don't manage to solve it..

I have two drop-downs lists containing series of letters, the second depending on the first one :

2jcj7rr.png

First of all, my macro aims to :

1) Populating the Excel sheet Spedizioni aperte with data, letting the column F (for the first list) and G (second dependent list) blank.
2) Initializing the Table and the Ranged names from the sheet Info
3) Get the data range from the sheet Spedizioni aperte
4) Populate this range in the column F with the first data validation list and G with the second one

Here's my function for points 2) to 4):

Please Login or Register  to view this content.

When I launch the macro, the table and Named ranges are created and the column F is populated correctly but I get an "Error 1004" while it tries to insert the data validation list on the column G.

Senza nome2.png

Does someone have an idea?

I need a fresh eye
Thank you very much for your help !

Fabien.

I think the error is occurring because data validation already exists on column G. Try clearing the data validation from column G before you run the macro and see if that helps.

Hello Danerida

No, I always clear all the data before running the macro again. And you can see that I use the ".Validation.Delete" method before selecting the range in column G.

In the meantime I solved the issue.

It was due to the default value I insert in each cell in column F ("Selezioni...") before creating the data validation list in column G. This value doesn't exist in the first drop-down list so I got an error. Instead, if I initialize the value of each cell in column F with "LIV" or any existing value in the first drop-down list ("MLV", "ARR",...), it works.

Thanks anyway