Thread: hold random numbers

im trying to construct a mini slot machine. i created a macro which provides three random numbers.

i now need to create another which can hold the doubles that show on a1 and a2.

i tried creating a seperate macro button which basically provides another random number in a3 but for some reason it randoms cells a1:a3 again.

any help how to configure this in excel?

Originally Posted by ma501th

im trying to construct a mini slot machine. i created a macro which provides three random numbers.

i now need to create another which can hold the doubles that show on a1 and a2.

i tried creating a seperate macro button which basically provides another random number in a3 but for some reason it randoms cells a1:a3 again.

any help how to configure this in excel?

That's correct. The RAND() function is volatile and will re-evaluate every time a change is made on the sheet. To achieve your objective you will need to get the macro to convert A1 & A2 to Values by copying and PasteSpecial values. Then of course you'll need to make the first action of the macro one that enters the =RAND() function in A1:A2.

HTH

if your first spin gives 3 1 3 you presumably want to hold reels 1 and 3 and respin 2?