Hi OllieB, once again many thanks for your help. I cannot seem to incorporate your code into my initial sub. In the meantime I have convinced my client to just copy and paste into a different sheet and save as .csv :D