title: Random element from array in Excel-VBA
body: <p>I've stormed the internet and still have not found any solution to this question:</p>
  
  <p>I have an array like so;</p>
  
  <pre><code>Dim PayRate As Variant
  PayRate = Array(10, 20, 30)
  
  Cells(i, "E").value = PayRate(Int((2 - 1 + 1) * Rnd + 1))
  </code></pre>
  
  <p>but this will only give me 20 and 30 from the array (elements 1 and 2), I also want element 0 = 10 in the mix ? How do I got about doing that?</p>