Function VBARnd(Optional ByVal Volatile As Boolean = True)
Application.Volatile Volatile
VBARnd = Rnd()
End Function
is there a formula that can be used instead of randbetween(min,max), or rand() that would return a random number that wont change everytime you do something else on the spreadsheet?