Thank you Colin (and Tony).

Did a find and replace of the code and it works beautifully.

I have spent many a frustrating hour looking at it. Checking ranges etc, but I don't think I would of ever figured it out.

But you only know what you know and I know the more I learn the less I know.

But I also know that I won't forget it as we learn by our mistakes (or lack of knowledge).

Much appreciated, I'll mark the problem solved, if I can't find out how to that simple thing can you do it for me and mark it as an EXCELlent response from an EXCELlent forum.