Jump to content

Recommended Posts

Posted

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

Posted (edited)

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 by jheinze
  • 6 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...