Hi Jerry,

Thanks very much for your reply, it very definately works.

Out of interest is there any way to achieve the same thing with out the named ranges as I will likely end up with around 100 named ranges in the workbook?

Regards

Ads