title: excel macro cells.find won't use variable for some reason
body: <p>I have this code as an excel macro.</p>
  
  <pre><code>  Dim MyData As DataObject
    Set MyData = New DataObject
    MyData.GetFromClipboard
  
    MsgBox MyData.GetText
  
    On Error GoTo NotFound
    Cells.Find(What:=MyData.GetText, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
    :=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
    False, SearchFormat:=False).Activate
  
    NotFound:
  </code></pre>
  
  <p><strong><code>MsgBox</code> writes the value correctly, but the <code>What:=MyData.GetText</code> just won't work. Why? Or, more importantly, how to fix it?</strong></p>
  
  <p>If it is not clear, I am trying to find the next value equal to the one in clipboard at the moment. I have referenced the MSForms so that is not the problem.</p>
  
  <p>If I assign MyData.GetText to a variable and use the variable, the same happens, <code>MsgBox</code> works, BUT <code>What:=myvariable</code> doesn't.</p>