title: Get the data from copied filtered cells
body: <p>If I copy some cells (simply containing numbers) from filtered column, how can I further reference this data from VBA?</p>
  
  <p>If I try this:</p>
  
  <pre><code>Dim DataObj As MsForms.DataObject
  Set DataObj = New MsForms.DataObject
  
  DataObj.GetFromClipboard
  
  Debug.Print DataObj.GetText(1)
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>DataObject:GetText Invalid FORMATETC structure
  </code></pre>
  
  <p>Is there any other way to access the data from copied filtered cells?</p>