How to stop Random

[BurningWing]

Hey who ever is reading this.

I'm facing this problem, i'm trying to make a knockout tournament line up on
excel, and i've got it to randomize the positions from 1st to 12th, but every
time i press enter it randomizes it again which stuffs up the tournament
order. Is there anyway i can stop it from randomizing like that?

Thanks

 

[Nigel]

How are you randomizing?

 

[JLGWhiz]

Sounds like the OP put the code in a Worksheet_Change or
Worksheet_SelectionChange event. Should have been in the standard module.

 

[Gord Dibben]

Turn off calculation or change formulas to values.


Gord Dibben MS Excel MVP

 

[Bernd P]

Hello,

You can take my UDF [VB]UniqRandInt:
http://www.sulprobil.com/html/uniqrandint.html
Comment the row with "Application.volatile".

Regards,
Bernd