Hood And Art
A big thank you for your patience with this problem.
I have solved the problem but i don't know exactly what the problem is or how it came about.

Hood your last post convinced me that it was all my fault, naturally.
So i used the standard macro folder and renamed it to my profile after renaming the original folder BAD
I ran the code it worked as it should, i then copied over my tool folder from the bad folder into the standard renamed tool folder, ran again still OK
The problem is I have lots more macros in the bad folder and some that are missing.
Phil