LinkBack URL
About LinkBacks
I am working with randomly generated numbers and am looking for an excel function that will store each randomly generated number in a cell as it is generated.
I am working with randomly generated numbers and am looking for an excel function that will store each randomly generated number in a cell as it is generated.
How are you generating the numbers?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
The numbers are being generated using a randbetween function nested inside an index to select a random row number from a given column.
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).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks