Results 1 to 6 of 6

Thread: Speed up the loop process (Copy paste Value)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jun 2019
    Posts
    5
    Location

    Speed up the loop process (Copy paste Value)

    Hi,

    I'm still very beginner in VBA.

    I have this VBA code below:

    Sub Iteration()
    Application.ScreenUpdating = False
    Dim i As Integer
    Dim j As Integer
    j = Range("C14").Value 'Can be up tp 10,000 iteration
    For i = 1 To j
    Range(Cells(i + 1, 19), Cells(i + 1, 20)) = Range("P20:Q20").Value
    Next i
    Application.ScreenUpdating = True
    End Sub
    The loop process or iteration can be up to 10,000, but it will take like 10 minutes to run.
    Appreciate if anyone can help me to speed up the process.

    Thanks in advance.
    Last edited by Aussiebear; 06-07-2019 at 03:26 AM. Reason: Added code tags to wrap submitted code

Posting Permissions

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