Copy and paste Excel Cells range

[phan423 0]

I'm having trouble trying to copy and paste a range of cells from excel to another excel sheet. I don't want to have to use a loop and go through each cell and copy and paste it. Any faster method? I tried using:

$a=_ExcelReadCell($oExcel1, "C2:E2")
ClipPut($a)
WinActivate($sWindow2)
send("^v")

not sure if i'm defining the range correctly because it pastes an empty string

[jhtromb 0]

Take the following functions:

_ExcelCopy($excelfile, "C2:E2")
_ExcelPaste($excelfile2, "A1")

For A1 you take the cell in the second file where the pasting starts!

Hope that helps!

Edited March 28, 2012 by jheinze

[Fabinho 0]

tks, but it's returnin an error:

[Fabinho 0]

I got it!!!

I changed like this:

_Excel_RangeCopyPaste($oWorkbook.Worksheets(1), "L4:O4")

And worked!!! thank you!!