Tom

The error message I recieve is a 1004 Application defined or object defined error, rather none descript. I wasn't aware you need one visible sheet in a book, this maybe my problem. I will test it an add another posting if it is unsuccessful

Thanks