Somehow copy is happening but the paste doesnt happen. could someone please guide me???

But are you checking for errors?

Troubles transposing a range in Excel with Win32::OLE maybe related.