How to FIX a RAND-BETWEEN Alternative Macro in Excel

Question

I am looking for a RandBetween Altermative that has the exact same function but remains constant. I was looking for a macro that woould do just that and I thought I found one...

Function RndInt(lowerbound As Integer, upperbound As Integer) As Integer
Static AlreadyRandomized As Boolean

If Not AlreadyRandomized Then

Randomize

AlreadyRandomized = True

End If
RndInt = Int(lowerbound + Rnd() * (upperbound - lowerbound + 1))
End Function

After testing it, it looks like the problem is that the function doesn't choose between the cells but it only takes just the values of the upperbound and lowerbound cells and doesnt function as the RandBetween function where you can coose an upper and a lowerbound cell and it will pick from all the cells between these two cells :/

Answer 1

Your posted VBA does exactly what you described (RANDBETWEEN choose from a range of numbers, not from range of cells), maybe you should use it in a different way:

=INDEX(A1:X1,RndInt(1,COLUMNS(A1:X1))
where A1 and X1 are first and last cells in your range