Hi @Kyle123, thank you very much for this. I think I'll have to see if I can find another example to work with Excel 2013 because all the code you suggested works, I would have to repeat multiple times for each part of my script which may become a little cumbersome.

Many thanks and kind regards

Chris