title: VBA Find function not working with variable
body: <p>I am creating a sheet that needs the application to search excel sheet for a value that is saved in a variable. <br>I am using the ".Find" function for this.
  <br>My problem is that the value being searched for can not be found while it is stored in a variable name although it works when i input an actual value. </p>
  
  <p>For example:</p>
  
  <p>this works </p>
  
  <pre><code>Dim cellersd, celltid, ersdcol, tidcol
  Set cellersd = book.Worksheets(mon &amp; yer).Range("5:5").Find("28/08/2013")
  Set celltid = book.Worksheets(mon1 &amp; yer1).Range("5:5").Find("30/09/2013")
  
  If cellersd Is Nothing Then
  MsgBox "not found"
  Else
  MsgBox cellersd.Column
  End If
  
  If celltid Is Nothing Then
  MsgBox "not found"
  Else
  MsgBox celltid.Column
  End If
  </code></pre>
  
  <p>this doesnt work </p>
  
  <pre><code>rsd = Worksheets("workload").Range("p4").Value
  tid = Worksheets("workload").Range("p3").Value
  ...
  
  Dim cellersd, celltid, ersdcol, tidcol
  Set cellersd = book.Worksheets(mon &amp; yer).Range("5:5").Find(rsd)
  Set celltid = book.Worksheets(mon1 &amp; yer1).Range("5:5").Find(tid)
  
  If cellersd Is Nothing Then
  MsgBox "not found"
  Else
  MsgBox cellersd.Column
  End If
  
  If celltid Is Nothing Then
  MsgBox "not found"
  Else
  MsgBox celltid.Column
  End If
  </code></pre>
  
  <p>The ... in the code just shows that i have other codes inbetween which perform different actions</p>
  
  <p>Can you spot my error?
  i am also open to suggestions on other search methods that could equally work. 
  Thanks a lot.</p>