Hello,
This is my first post, so I apologize in advanced for any errors or novice interactions.
I have noticed that the Rnd Function repeats exactly the same pattern each time I close the workbook.
I am running a dice macro for a board game. It is turn base for 7 players, after each roll the player closes the workbook (it autosaves) and the next player opens the workbook to roll their dice.
The problem is that each time the workbook opens the int((6 - 1 + 1) * Rnd + 1) produces the exact same number as the previous turn. I thought it was an anomaly so I tested it. I ran the macro a few times and kept track of the numbers it produced, sure enough it seemed random. I closed the workbook and ran the dice again. To my surprise, I found that the macro provided the exact same numbers in the exact same order.
I am having a hard time finding a work around so that the numbers are 'truely' random each time.
Regards,
ChesterU
This is my first post, so I apologize in advanced for any errors or novice interactions.
I have noticed that the Rnd Function repeats exactly the same pattern each time I close the workbook.
I am running a dice macro for a board game. It is turn base for 7 players, after each roll the player closes the workbook (it autosaves) and the next player opens the workbook to roll their dice.
The problem is that each time the workbook opens the int((6 - 1 + 1) * Rnd + 1) produces the exact same number as the previous turn. I thought it was an anomaly so I tested it. I ran the macro a few times and kept track of the numbers it produced, sure enough it seemed random. I closed the workbook and ran the dice again. To my surprise, I found that the macro provided the exact same numbers in the exact same order.
I am having a hard time finding a work around so that the numbers are 'truely' random each time.
Regards,
ChesterU
