Data Validation and Indirect Function

Hi

I have a problem regarding using lists with the indirect function. I have a series of class names and each has a named range associated.

Each class has a secondary named range that is used for including or excluding names and that removes each name as it is used.

I am trying to use Indirect so that by entering the class number the relevant list appears -

However the function will not work in the sheet I am working on, I have tried it in another sheet and everything is fine, so the problem is in the workbook, unfortunately it is a rather large workbook as well.

I was wondering if anyone else had come across something similar.

Thanks in advance

Regards


Jeff