macro for random number in 2 cells

[fastballfreddy]

i know how to use rand between formula but only want the numbers changed when i want them to so I need a macro that will generate random whole numbers between 1 to 6 in cell A1 and B1 with click of macro button. Thank you in advance!

 

[DanteAmor]

If it doesn't matter if the numbers repeat, try this:

Sub Random_Num()
  Range("A1") = WorksheetFunction.RandBetween(1, 6)
  Range("B1") = WorksheetFunction.RandBetween(1, 6)
End Sub

 

[fastballfreddy]

Thank you Dante! Worked great!