Hi,
Smitty -- Rand() is a volatile function, so it will recalculate upon any change to the workbook, not including formatting changes like adjusting column width, etc..
Workarounds...
1. Turn calculation to Manual (not recommended in most cases)
2. After entering the formula, choose Edit>PasteSpecial>Values. You will lose the formula but retain the value.
3. Write a UDF such as the following
Code:
Function StaticRand(Optional Multiplier as Double) As Double
StaticRand = Rnd * IIf(IsMissing(Multiplier), 1, Multiplier)
End Function
Note that VBA's Rnd has a different period than does Excel's RAND() function, but the difference would only be noticed when doing seriously intensive stats work.
4. Search this site for Eric Dysart and visit his webpage. He has a downloadable file that has exactly what you want, but requires the add-in to be loaded.
5. I am sure I am missing some option.
