Welcome the the Board!I am using =rand()*99 to produce a random percentage, however, I do not want the generated number to change with every keystroke. I'd like it to be stored, in either that cell or, if that's not possible, another cell.
Function StaticRand(Optional Multiplier as Double) As Double
StaticRand = Rnd * IIf(IsMissing(Multiplier), 1, Multiplier)
End Function
Jay Petrulis said:---cut---
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.
---cut---