View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
A Mad Doberman A Mad Doberman is offline
external usenet poster
 
Posts: 22
Default random number generation help

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!