Macro to Refresh Random Numbers on Worksheet or Freeze Them

[xjohnson]

Hello,

Is it possible to have a macro to refresh the random numbers on the 2017 Stats! sheet and another one to freeze them so they don't change? By freezing I mean to keep them until clicking on the 'Refresh Random Numbers'.

Thank you for your help,
XJ

[6StringJazzer]

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

[xjohnson]

Thank you for the suggestion