Cheers Deb,

Not a problem, I've just ran the code and it worked fine, Just one question..is there a way to make case Q or I non case sensitive because it saves to the report folder when they are in lowercase?

Thanks for your help with this, it's much apreciated!

Regards
Carl