Duplicate Value in a clear print area

[RJ1969]

Hi,
I have a worksheet that I set a Clear Print Area.

I added this code in A4, So I don't get a duplicate entry in column A.

=COUNTIF($A$4:$A$1048576,A4)=1

I know how to set this in the data validation. After I set the code, I have to drag it down the code in every cell.

I want to avoid dragging it down because if I do then the "Clear Print Area" that set will be useless.

Is there anyway suggestion to avoid dragging the code down?

Thank you

[BadlySpelledBuoy]

You could use a Table then apply the same custom validation rule to that.
As you enter more rows of data the table expands and copies the validation rule down with it.

Other that that you'd probably be looking at a VBA approach to it. A simple worksheet change event to check if any value in column A is repeated each time it's changed.

BSB