title: VBA find last occurrence of a string
body: <p>I've been trying to work this problem out for a few days now and I just can't get my head around it. I have searched multiple websites (Even here several times), I have seen that many people have asked this question but the solutions don't work for me.</p>
  
  <p>I want to find the last occurrence of a string in a range and store the address in a variable and display a message telling me where it is.</p>
  
  <p>So far I have this</p>
  
  <pre><code>Private Sub CmdBtnClockIt_Click()
    Dim job As String
    Dim searchTerm as Range
  
    job = CmbBoxJob.Value
    searchTerm = Range("A1:A999").find(what:=job, searchorder:=xlByColumns, searchdirection:=xlPrevious).Column
    MsgBox "last cell is " &amp; searchTerm.Address
  End Sub
  </code></pre>
  
  <p>All I seem to get is either "invalid qualifier" or "object variable or with block variable not set"</p>
  
  <p>Any help is appreciated</p>