Holger - excuse me if I had previously seemed ignorant my VBA skills are very very basic and my knowledge is self taught through forums such as this. Your help has been appreciated!! The above code has worked and I have learnt something new! thank you