setting loop code to check all named sheets

[bakerman]

Tested Alan's code and made some minor changes.
This does the trick for me.
Try it out and feel free to ask if you have any further problems.

[peter renton]

Thanks Bakerman

that works spot on, i would never have got there in a month of sundays

thanks also alan for your assistance..

Peter:-)

[alansidman]

You are welcome. Thanks for the Rep.