=rand()....Help?!
Okay, so I'm working on my maths coursework, and I'm using the =rand() calculation. But every time I click, or press enter elsewhere, the numbers change..other than writing out all the numbers that are generated..does anyone know how to get the numbers to stop changing???
Much appreciated.
xx
Go to Tools\Options\Calculation and set it to Manual recalculation
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
or after manual calculation, copy and paste the random numbers as values so they can not change
Regards
dav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
britishpunk 
Register To Reply
Bookmarks