I have coded my workbook for case formatting and counting total of cells colours, it works BUT I need to select the cells with the formula and manually return to refresh.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
I can get round this by...