1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Paste to workbook

Discussion in 'VBA Macros' started by coolkiran, Feb 13, 2019.

  1. coolkiran

    coolkiran Member

    Messages:
    138
    Hello all

    I have 2 workbooks, From my macro file i am trying to open one work book, copy all rows and paste into another workbook.

    Current problem is , i have around 100,000 records. Its taking lot of time with current macro. and also screen will freeze. Is there any way to improvize below code.

    Code (vb):

    totalRow = ActiveSheet.Range("A1048576").End(xlUp).Row
    wkb.Sheets("Sheet1").Range("A1:BZ1048576").Value2 = ActiveSheet.Range("A1:AZ" & totalRow).Value2
     
    Note : wkb is destination workbook where i am pasting data..
  2. coolkiran

    coolkiran Member

    Messages:
    138
    Any suggestion would be great....
  3. vletm

    vletm Excel Ninja

    Messages:
    4,793
    coolkiran
    ... with which macro, it takes a lot of time?
    Those two lines won't work alone!
    Upload a SAMPLE file...

Share This Page