Thanks so much, I did not mean to have HL twice.

Basically you have two columns, one with Sector and one with Sub Sector.

Colum AM has lists of 9 sectors, and I want to create a list in AN of Sub
Sectors which depend on what was selected in AM.

When I try the script you gave, Excel tells me I cannot use Arrays in the
Validation thingy.

--
Message posted via http://www.officekb.com