Hi Pike,

You've been great. I did repeat the error post only to specify the error as I thought perhaps someone might have helped if you were offline.

I will delete the other post.

I think this works great however as I am currently try to run it on 2007 itis saying I cannot save to macro free workbooks. I've been to the trust centre and change the settings but still doesn't work.

I'm sure it will work fine in the office on the 2003 version though which is what it needs to work on so thank you very much.

I appreciate all your help on this.

Thanks again
Libby