Hi,

I would be most grateful if someone could offer some help or advice.

I wish to Validate a range of cells from D4 to D100 which will only allow
the following:

1. only a 7 figure number to be entered.
2. to not allow a duplicate 7 figure value to be entered.

Many thanks,

Simon.