Thanks for the feedback.

Learning something new every day has been my goal in life.


Gord

On Fri, 08 Dec 2006 13:07:55 GMT, Martin ©¿©¬ lid wrote:

On Thu, 07 Dec 2006 09:32:07 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

The first two lines are doing nothing so you could delete them.

The Worksheet_Change code works for me.

If you want it available for all sheets place it in the Thisworkbook module

Thank you very much Gord, I didn't know that
That's another thing I've learnt today

Gord Dibben MS Excel MVP