I generally try to avoid using anything from the Analysis ToolPak whenever
possible. You never know if a user you distribute your workbook to will have
it installed or not, or if they'll even know what an Add-In is. Plus the
problem you've run into where Excel doesn't seem to want to activate it.

The RANDBETWEEN function can be duplicated using the ROUND and RAND
functions (which does not require any Add-Ins).

=ROUND(RAND()*(B1-A1)+A1,0)

Where A1 is the low number in your range, and B1 is the high number.

HTH,
Elkar



"ALee" wrote:


On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
If necessary, follow the instructions in the setup program.

I did the first two steps several times and still got #NAME.
So, I should do the third step, but HOW?ALee