title: Get the reverse index of a value from Array in VBA
body: <p>I have an integer array.</p>
  <pre><code>Dim a as Variant
  a = Array(1,2,3,4,1,2,3,4,5)
  Dim index as Integer
  index = Application.Match(4,a,0) '3
  </code></pre>
  <p>index is 3 here. It returns the index of first occurrence of 4. But I want the last occurrence index of 4.</p>
  <p>In python, there is rindex which returns the reverse index. I am new to vba, any similar api available in VBA?
  Note: I am using Microsoft office Professional 2019
  Thanks in advance.</p>