title: VBA Excel 2010 - Paste directly from clipboard
body: <p>I am trying to paste directly from the clipboard into an excel document and have it so it is transposed</p>
  
  <pre><code>Dim DataObj As MSForms.DataObject
   Set DataObj = New MSForms.DataObject
   DataObj.GetFromClipboard
  
  strPaste = DataObj.GetText(1)
  
  strPaste.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
  False, Transpose:=True
  </code></pre>
  
  <p>The <code>strPaste</code> does have the correct data but it bugs out on the <code>.PasteSpecial</code> saying object required</p>