Thread: RANDBETWEEN
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pkeegs pkeegs is offline
external usenet poster
 
Posts: 46
Default RANDBETWEEN

I have a worksheet which generates a random number between two base numbers
using the RANDBETWEEN Function. Whenever I close the sheet and reopen, the
workbook won't recognise the function. I go into the add-ins and check the
Analysis Toolpak option, reset my number and it works fine - until I open it
after closing. Again I have to go in and recheck the Analysis Toopak. Any
suggestions as to what is going on.

Regards - Peterk