Thread: RANDBETWEEN Does Not Accept a letter variable

I am trying to generate a random number between 2 and an integer inputed by the user through an InputBox which I call say 'k'. The code
ActiveCell.FormulaR1C1 = "=RANDBETWEEN(2, k)" does not work. It works only if I replace k by an integer greater than 2. I have checked that The variable k does equal the integer provided by the user. Thanks for the help

Try it like this:

ActiveCell.FormulaR1C1 = "=RANDBETWEEN(2," & k & ")"

Hope this helps.

Pete