Sign in to follow this  
Followers 0
phan423

Copy and paste Excel Cells range

2 posts in this topic

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

Share this post


Link to post
Share on other sites



#2 ·  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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0