drawing of lots

  • Thread starter Thread starter Martyn Wilson
  • Start date Start date
M

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
 
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?.
 
Hi JE McGimpsey,
That did it!. Thanks a lot.
So does that means that every UDF need to be in regular code module?
 
Back
Top