LinkBack URL
About LinkBacks
The way I would do this is by populating the random numbers using VBA instead of formulas. Then you don't have to worry about "freezing" them.
For example, you could simulate RANDBETWEEN(1,14) with
Cell.Value = Int(Rnd()*14) + 1
The way I would do this is by populating the random numbers using VBA instead of formulas. Then you don't have to worry about "freezing" them.
For example, you could simulate RANDBETWEEN(1,14) with
Cell.Value = Int(Rnd()*14) + 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks