Jump to content
Sign in to follow this  

Copy and paste Excel Cells range

Recommended Posts

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")

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

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...