Can I create a random number without Analysis ToolPak?

[rkjudy]

I have a complex workbook with many sheets and many macros. I need to generate a random number in a particular cell on one of the sheets. I tried using RANDBETWEEN, but it returned #NAME? because Excel said it required the Analysis Toolpak Add-in. I loaded this Add-in and it worked fine, but it slowed my workbook down to a crawl. I uninstalled the Add-in and it went back to working just fine. Is there anyway to create a random number, say between 10000 and 99999 without the Analysis Toolpak or otherwise slowing down my workbook?

[NBVC]

Try

=INT((99999-10000+1)*RAND()+10000)

[rkjudy]

Perfect Solution!