Simple Macro to re-trigger RANDBETWEEN

[Matman67]

I want a button to trigger all of my RANDBETWEEN cells to re-randomize.
What's the simplest macro should I use to do this?

I was copying/pasting a cell, but this changes the selection.

Thanks in advance.

 

[Rick Rothstein]

I want a button to trigger all of my RANDBETWEEN cells to re-randomize.
What's the simplest macro should I use to do this?

Doesn't simply pressing the F9 key do what you want?

 

[Matman67]

It does, but I specifically want the action to be triggered by the button.

 

[Matman67]

Got it:

Sub RANDO()
Application.CalculateFull
End Sub