Thanks for this one Steffi, for some reason it keeps erroring out :(

'If not.....' line is in red, as is the 1)) and the "Apply" string and the
=not.

I tried putting the ' infront of the commands but it's not running. I'm not
exactly sure what I'm doing wrong, I'm a bit of a novice at VBA.

Best regards,

Gareth