| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
| with random No's calc how can I stop two different columns predic. | Excel Programming | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
| Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
Linear Mode
