VBA Excel 2010 - Paste directly from clipboard
<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>