Results 1 to 4 of 4

Copying and pasting repeatly over 5000 rows (Macro).

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Copying and pasting repeatly over 5000 rows (Macro).

    HI to all,

    I have recorded a macro to copy and paste two different location.

    At each row # under column B to U and paste to V1 (in the range V1 to AO),
    and wait for all values to change over 5000 rows of 20 columns across (V1 to AO1).
    Then copy at location range D2:U2 and paste to column AR1 (in the range AR1 to BI1)
    to over 5000 rows 18 columns across.

    The recorded macro below, I want to this macro modified to automatically to run by
    itself from beginning to the end of range (over 5000 rows).

    I don't want to keep on copying and pasting each rows over 5000 rows.
    Range("B1:U1") keep on changing until it reach over Range("B5000:U5000") end of
    range.
    Range ("AR1") keep on pasting until it reach over Range ("AR5000") end of range.

    Please noted*** that Range("D2:U2") and Range("V1") are one single row only, these
    don't changed and stay as they are in the macro.



    Sub Lottocount()
    '
    ' Lottocount Macro
    '
    
    '
        Range("B1:U1").Select
        Selection.Copy
        Range("V1").Select
        ActiveSheet.Paste
        Range("D2:U2").Select
        Application.CutCopyMode = False
        Selection.Copy
        Range("AR1").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Range("AR1").Select
    End Sub





    Any help will be appreciated, thanks.

    Greg
    Attached Files Attached Files
    Last edited by GregOgie; 08-29-2012 at 04:26 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

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

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