Works a treat!!! Thanks very much.

Have a good weekend.

Louise

"Max" wrote:

Error in pasting, sorry

Line
Formula: =COUNTIF($1:$65536,A65494)<2

should read:
Formula: =COUNTIF($1:$65536,A1)<2
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----