Hi, I have now tried various runs and have identified the fact that the code only stops if one of the rows doesn't have data in every column. I think I can work around that so Thank you again for your expertise, I'll let you know how it progresses, good night, Thanks Regards, Peter.