Yes Ben, i also think there is a bug in SendKeys function.I have written about this on Microsoft Website but i am yet to get a satisfactoy reply.
You can also see the thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=656335&SiteID=1 where I was initially trying to enter data in cell A1 and then copy it to cell B2. But it used to enter data in cell B2 only and cell A1 was left blank.
Recently the code has been updated in my thread where now the second argument of the Sendkeys fuction namely. True also doesn't works.as against the Excel Help files which states...
expression Optional. An expression that returns an Application object.
Keys Required Variant. The key or key combination you want to send to the application, as text.
Wait Optional Variant. True to have Microsoft Excel wait for the keys to be processed before returning control to the macro. False (or omitted) to continue running the macro without waiting for the keys to be processed.
Can we have some Excel MVP or Microsoft ISV team comment on this