I want to click a button and have 5 different cells return 5 numbers between
1 and 6 i want each cell to pick number randomly it does not matter if some
numbers are the same. then i want to be able to select some cells and do not
want those numbers to change on next click. want a max of 3 clicks. This is
for a version of dice or yathzee im trying to create. hope you can help

If you have the Analysis ToolPak installed, you can use RANDBETWEEN to
generate your random numbers - see Excel Help for further details.

To stop the random numbers re-generating every time you make a change,
you need to set the calculation mode to manual - click on Tools |
Options | Calculation tab. Then you can just press F9 to recalculate
when you want to.

Hope this helps.

Pete

On Nov 8, 10:20 pm, jimE wrote:
I want to click a button and have 5 different cells return 5 numbers between
1 and 6 i want each cell to pick number randomly it does not matter if some
numbers are the same. then i want to be able to select some cells and do not
want those numbers to change on next click. want a max of 3 clicks. This is
for a version of dice or yathzee im trying to create. hope you can help