Hi,

I wanted to prepare a macro which defined cell range to entry only 8 different numbers between themselves.
For an example;

Sheet1(A1:B10) 20 cells range are unprotect.
Users enrty this cells 8 different numbers between themselves (max 99).
Users can be entry these numbers 1,2,3,4,5,6,7,8, or can be 1,2,2,3,3,4,5,6,6,7,7,8,8 like this.
But if users entry 1,2,2,3,3,4,5,6,6,7,7,8,8,9 like this, macro must block to entry number nine.

My language is not very good , i hope i can explain what i want to.
If you need more information, let me know.
Thanks