Obsessed,

many thanks for you reply it is very much appreciated. I ran the macro and it worked as required...however, when I ran it again to see what would happen I got a 'Run-time error '1004':'. Do you know how to amend the code to check if no data needs to be processed and thus avoid a 'Run-time error'

Many thanks

Rob