Data Validation List

Hi,

Several sheets in one work book with Data Validation list based on a Named Range (Names_1). I have deleted the Named Range accidentaly. The original Named Range is still found as a source of the Data Validation List.
I created a new Named Range (Names_5) and I want to use it instead of the old one. Is there a way to do this automatically for the reltaed worksheets ? I don't want to do it manually since I have a large number of sheets.

Khalil

Why don't you just rename your Names_5 list to Names_1?