Is it possible to have a macro that will control the number of rows that data validation drop down lists are copied down to in a worksheet?


More info:
I have a sheet that contains data that goes down as far as row 400 and includes some columns with drop down lists copied down also as far as row 400. However during use, the user will delete any number of the rows above as data become obsolete and so (unless I am mistaken) this means that they will eventually start adding data into rows that don't have data validation.

I would like a macro that automatically ensures that cells down as far as row 400** always have the appropriate data validation lists copied down for that column

**(ideally this number, i.e. row 400, will also be controlled by using some kind of indirect reference, taking the number '400' as entered in a cells of a another sheet I have which is currently controlling the bottom row cell reference for various named ranges through an indirect function.)


Thank in advance for any assistance!