Hi Norman,

Hmmm... resetting last cell (column) ... once columns are colored they
will be part of the used range. So can only expand to right it
seems...

Unless the usedrange gets evaluated not taking into account row 1&2.

It will serve its purpose like this I guess.

Sige