Results 1 to 9 of 9

Make copy macro faster

Threaded View

moosmahna Make copy macro faster 10-15-2023, 11:00 AM
TMS Re: Make copy macro faster 10-15-2023, 11:04 AM
moosmahna Re: Make copy macro faster 10-15-2023, 11:18 AM
TMS Re: Make copy macro faster 10-15-2023, 11:23 AM
moosmahna Re: Make copy macro faster 10-15-2023, 11:29 AM
moosmahna Re: Make copy macro faster 10-15-2023, 12:10 PM
TMS Re: Make copy macro faster 10-15-2023, 11:27 AM
TMS Re: Make copy macro faster 10-15-2023, 12:14 PM
TMS Re: Make copy macro faster 10-15-2023, 01:18 PM
  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Austria
    MS-Off Ver
    Excel 2016
    Posts
    169

    Make copy macro faster

    Hy,
    I have a worksheet with a lot(!!!) of data in cells A to G. I have to copy them one after another to another workseet in the same workbook but copy them for 8 times. I already have a macro but it gets always slower and slower when copying hundreds of rows.
    Here is my macro:

    Sub kopieren()'Copy range
    
    Dim rng1 As Range
    Set rng1 = Sheets("1").Range("A1:G1")
    
    rng1.Copy
      Sheets("2").Cells(Rows.Count, "A").End(xlUp).Offset(1). _
        PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
      Application.CutCopyMode = False
    
    End Sub
    
    Sub multiple()
    
    Dim i As Long
    For i = 1 To 8
    Call kopieren
    Next
    
    End Sub
    
    Sub ErsteReiheLoeschen() 'Delete first row when copy done
    Dim ws1 As Worksheet
    Set ws1 = Worksheets("1")
    
    ws1.Select
      Rows(1).EntireRow.Delete
    End Sub
    
    Sub Einzeln()
    Call multiple
    Call ErsteReiheLoeschen
    
    End Sub
    
    Sub Start()'Start all macros
    
    Dim z As Long
    For z = 1 To 2000
    Call Einzeln
    Next
    
    End Sub
    Can you help me please
    Thanks a lot Roman
    Last edited by moosmahna; 10-15-2023 at 11:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make this macro faster?
    By thesisexcel in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-03-2021, 11:28 PM
  2. Is there a way to make this macro go faster?
    By tkbuc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2020, 12:26 PM
  3. Make Macro Run Faster
    By quepes13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2014, 02:23 PM
  4. How can I make this copy paste function faster???
    By just_helping in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2012, 11:49 AM
  5. make faster copy paste or formula to assist in copy
    By gill389 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2010, 02:07 AM
  6. Replies: 2
    Last Post: 11-15-2010, 02:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1