I am trying to create random numbers between a certain range. say, (2,10)

how do i do this thru VBA code?

i tried RANDBETWEEN(2,10) but its doens't seem to recognize this as a fucntion...