Hi,

I am working on a worksheet that contains 20 Rectange boxes created by the
user.

Is there a way using VB to check the number (which falls between 1 and 21)
in a seperate Rectangle box - say Rectangle 50
then plot each seperate Rectangle box numbers 1-20 with the numbers 1-20
excluding the number found in Rectangle box50

eg - Rectangle box50 contains number 3

VB code will put
number 1 in Rectangle box 1
number 2 in Rectangle box 2
number 4 in Rectangle box 3
etc
etc

hope this makes sense?
thanks