RANDBETWEEN is an Analysis ToolPak function. To load this go to
Tools>Add-ins> and check the Analysis ToolPak. (Not the one for VBA unless
you intend to implement them in code)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)