RANDBETWEEN No Repeats w/ VBA Macro Button

Hey All,

I believe this is a fairly easy problem I am trying to solve, but I'm still in the beginning stages of learning VBA. I created a macro button that places random numbers in 6 assigned boxes. However, I cannot have any repeat numbers. I don't know how to implement the "no repeat" syntax into my code. Any help would be appreciated.

Sub Test()
    With Range("RandomTable")
        .Formula = "=RANDBETWEEN(1,6)"
        .Value = .Value
    End With
End Sub

Thank you,
Brandon


Random.xlsb