Code:Sub GenerateRandomNumbers() Dim lngFrom As Long, lngTo As Long Dim rng As Range lngFrom = InputBox("Enter from value") lngTo = InputBox("Enter to value. Should be greater than " & lngFrom) For Each rng In Selection 'Will error out if selection is not a range rng.Value = GETRANDBETWEEN(lngFrom, lngTo) Next rng End Sub Function GETRANDBETWEEN(lngFrom As Long, lngTo As Long) GETRANDBETWEEN = lngFrom + Int(Rnd() * (lngTo - lngFrom + 1)) End Function
Bookmarks