Named Range Problem

Hi

I have a question that I hope someone can assist me with.

I have ten named ranges relating to classes that are selected and then a dependent list is used for students to look up their names and enter a pin code to gain access to a test.

I would normally use dynamic ranges but I understand that the indirect function will not work with a dynamic range.

I have tried also using VBA to recreate the ranges if they change, but although I can recreate dynamic ranges I cannot get the "RefersTo" section to function correctly for a static range without empty cells.

My question is, is there a way to use dependent lists with dynamic ranges? Alternatively with a static range that is larger than the data contained within it, is it possible to have the first cell displayed rather than the first empty cell?

Many thanks for your comments

Regards


Jeff