Hi all,

I refer to this previous thread:

http://www.excelforum.com/excel-gene...cted-cell.html

The solution works really well however it clears any existing colors in cells eg column headings, etc.

Is there a way around this?

Regards,

Chris.