How to stop Random
 

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

How to stop Random
 

How are you randomizing?

--

Regards,
Nigel




"BurningWing" wrote in message
...
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

How to stop Random
 

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

"Nigel" wrote:

How are you randomizing?

--

Regards,
Nigel




"BurningWing" wrote in message
...
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

How to stop Random
 

Turn off calculation or change formulas to values.


Gord Dibben MS Excel MVP

On Mon, 19 Jan 2009 08:51:04 -0800, BurningWing
wrote:

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

How to stop Random
 

Hello,

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

Regards,
Bernd