Thank You very much under quick investigation it appears as though this will do everything i can throw @ it, I pasted the macro in my small example database i sent yesterday and i added some stencils here and
everywhere and it appears to work great. I will import this into my big workbook tommorow cross my fingers and I will report back as soon as possible. So Macropod do you do this as a living for MS? or do you just dabble on the side and moonlight as a Macro god! If the latter i would love to donate you have helped me tremendiously.