Thanks for the reply daffodil - but it didn't work either, does the same as my other code. Just does it for the first sheet. At the moment I've got 9 different sheets and it does it 9 times on the first sheet.

Any other thoughts?