Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
I am writing an attack simulator for a game I play. In the game, combat begins with ships on both sides attacking opposing ships at random. Part of my program contains a 2 dimensional array where a random number is assigned for each ship through a series of loops, if's, select cases, etc...For the random number assignment, I am using the code line: ATM(ShipCount, 5) = Int((TotalDefenseShips * Rnd) + 1) This appears to be working great and is randomly assigning numbers througout my array, as I want. HOWEVER, I have noticed that the series is the same with every run of the program. I need to alter my code so the random number does not follow the same sequence, even if I don't change any variables. With every run of my simulation, every point in the array must have a random number assigned to it that was different than the last simulation run. Any ideas? Thanks very much in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random Number Generation | Excel Programming | |||
RANDOM NUMBER GENERATION. | Excel Worksheet Functions | |||
Help for Random Number Generation | Excel Worksheet Functions | |||
random number generation | Excel Discussion (Misc queries) | |||
random number generation | Excel Worksheet Functions |