HI

Thanks for your comments.

I know how to create dynamic named ranges but the problem is using dependent named ranges via the INDIRECT function which does not work with dynamic ranges. At least as far as I can establish.

Regards

Jeff