Hi cat3rn,

You are correct - as soon as you ask for a button, you are involving macros.

RANDBETWEEN(0,9) will give you random numbers, but it is volatile, and it won't only use each number once. In other words, it is likely that you will get the same number used more than once in A1:A10. (Volatile means that it recalculates every time the worksheet calculates - that is almost every time you enter something!)

Is that what you want, or are you trying to get the digits 0 through 9 in a different order every time?

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".