XLent, you are a star.

Works perfectly for what I needed to achieve. Thank you.

Its funny how fixing one problem creates another in Excel lol, I now have issues in column B but that's another story which I'll try and fix. I'm really starting to love Excel and how powerful it is.

Again thank you!