in reply to Re^2: Win32::OLE Excel formula Copy
in thread Win32::OLE Excel formula Copy

If you want the behaviour of the copy & paste mechanism, you should try to use that: select the cells, copy them, move the cursor to another cell, paste there.

I'm not familiar with OLE at all, but I'm quite sure that this has to work somehow, and I even suspect you'll find some code examples if you search hard enough.