Confuse
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)

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> How can I get this function to work I read something about data analysis
> but
> i don't think that is what I want. Am I wrong?