Hi Charles,

Thanks for your help with this.

I see you have used the Worksheet Calculate event which is what I had in mind also.

I get a compile error when I open the workbook (named argument not found). It seems to have a problem with the 'SearchFormat'. If this works for you, I reckon you must be using a more recent version of Excel (I am stuck with 2003 !)

Anyway, you have given me a few ideas to play around with.

Thanks again for your help.


gtol