I have a number in B4 that will range from 1 to 7.

I need to randomly generate numbers (from 1 to 6) based on the number in B4.

If the number in B4 is:

1, I need 0 placed in cell B25 to B30

2, I need 1 number randomly generated (from 1 to 6) and placed in B25

3, I need 2 unique numbers randomly generated (from 1 to 6) and placed in B25-B26

4, I need 3 unique numbers randomly generated (from 1 to 6) and placed in B25-B27

5, I need 4 unique numbers randomly generated (from 1 to 6) and placed in B25-B28

6, I need 5 unique numbers randomly generated (from 1 to 6) and placed in B25-B29

7, I need 1 placed in Cell B25, 2 placed in cell B26, 3 placed in cell B27, 4 placed in cell B28, 5 placed in cell B29, and 6 placed in cell B30.

I think this must be done using VB. I have a small knowledge of VB, but I do have some books....

Thanks in advance...