Macro Button! help!

[TxcPhtm]

I need to make a Macro Program which makes a few cells random numbers I am
using '=RANDBETWEEN(0,100)' as my random source. I need to Make a Macro
button. I have done all of that but the I realized '=RANDBETWEEN(0,100)'
makes it so whenever I go to enter a Number in a cell to start solving the
randomized problem the numbers change. I need to know If there is a way two
Make a Macro button that you click on to Randomize numbers in a cell WITHOUT
changing when i change one cell.

 

[Gord Dibben]

Same question as earlier.

Stick with the same thread for best results and replies.

Where are you entering the "number in a cell"?

Not in one of the cells with the formula, I presume.

You can always turn calculation to manual to stop the randomizing until you want
to change.



Gord Dibben MS Excel MVP