To save a random number produced by RANDBETWEEN, you need to use VBA to convert the number to a value, and then store it where you want it. RANDBETWEEN is a volatile function, so its result changes every time there is a recalculation.

Your description is too general to give you the actual code to do this. If you would like a more detailed response, then describe your problem in detail, or attach a sample file (see yellow banner at the top of the page).