Number Generator

there is a typo in the code the first line should read

Function aiComboByNum(ByVal n As Long, ByVal t As Long, ByVal cNum As Long)

dont forget to array enter it with ctrl+shift+ enter
see here
http://office.microsoft.com/en-us/ex...872901033.aspx

Originally Posted by Chris

I went to the blank work sheet and entered: =aiComboByNum(75, 4, RANDBETWEEN(0, COMBIN(75, 4) - 1))
and the result is : #NAME?

Sounds like you didn't get the code installed. See attached. Before you open the workbook, set macro security to Disable all macros with notification, and then enable macros when prompted.

Originally Posted by Martin

there is a typo in the code the first line should read

There's no typo, Martin, it's correct as written.

Originally Posted by Martin

dont forget to array enter it with ctrl+shift+ enter

True, thanks for the emphasis.