When the clipboard contains only text the following code will paste it onto the desired cell.
Dim OBJ As New DataObject
OBJ.PutInClipboard ' this is just an example, the actual clipboard might have text and tabs and linefeeds etc
WORKS: ActiveSheet.PasteSpecial Format:="Text"
But, I don't like using Select statements. Is there anyway to do it completely without a select in Excel 2003? The following code fails with runtime error 1004
FAILS: ActiveSheet.Cells(3, 1).PasteSpecial Paste:=xlPasteValues
and, NO, I don't want to parse the clipboard text myself.
Also, I notice that the .PasteSpecial command automatically Selects what it has pasted, so I my ideal solution would eliminate that select also.