drawing of lots

[Martyn Wilson]

Hi,
Can a macro be written in order to draw numbers between 1-100 and keep
drawing excluding the numbers beeing drawn before?
TIA

 

[Dave Peterson]

J.E. McGimpsey has a userdefined function that you could put in A1:A100. It
will provide unique entries.

http://www.mcgimpsey.com/excel/udfs/randint.html

 

[Martyn Wilson]

Thanks Dave, but somehow I am not able to operate the UDF?. I've entered the
formula with a CTRL+Enter and I am getting a "#NAME" error on cells that are
trying to use the formula. The macro residing in the main workbook module
(tried it on the sheets as well)....Am I missing something here?.

 

[JE McGimpsey]

The UDF needs to be in a regular code module. See

http://www.mcgimpsey.com/excel/modules.html

 

[Martyn Wilson]

Hi JE McGimpsey,
That did it!. Thanks a lot.
So does that means that every UDF need to be in regular code module?

 

[Dave Peterson]

If you're going to call them from a cell on a worksheet, then yep.

 

[Martyn Wilson]

Thanks Dave.

If you're going to call them from a cell on a worksheet, then yep.