Results 1 to 19 of 19

My macro lags

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2018
    Location
    NJ
    MS-Off Ver
    Microsoft 365
    Posts
    15

    My macro lags

    My copy and paste macro sometimes take 15 to 20 seconds to run and bogs down it also gives me a clipboard error. It does work but is there a more efficient way to run this? I made this with recording the macro.

    Range("A3:A85").Copy Range("CC3,CD3")
    Range("E3:E85").Copy Range("CC169,CD169")
    Range("I3:I85").Copy Range("CC252,CD252")
    Range("M3:M85").Copy Range("CC335,CD335")
    Range("Q3:Q85").Copy Range("CC418,CD418")
    Range("U3:U85").Copy Range("CC501,CD501")
    Range("Y3:Y85").Copy Range("CC584,CD584")
    Range("AC3:AC85").Copy Range("CC667,CD667")
    Range("AG3:AG85").Copy Range("CC750,CD750")
    Range("AK3:AK85").Copy Range("CC833,CD833")
    Range("AO3:AO85").Copy Range("CC916,CD916")
    Range("AS3:AS85").Copy Range("CC999,CD999")
    Range("AW3:AW85").Copy Range("CC1082,CD1082")
    Range("BA3:BA85").Copy Range("CC1165,CD1165")
    Range("BE3:BE85").Copy Range("CC1248,CD1248")
    Range("BI3:BI85").Copy Range("CC1331,CD1331")
    Range("BM3:BM85").Copy Range("CC1414,CD1414")
    Range("BQ3:BQ85").Copy Range("CC1497,CD1497")
    Range("BU3:BU85").Copy Range("CC1580,CD1580")
    Range("BY3:BY85").Copy Range("CC1663,CD1663")
    Range("B3:B85").Copy Range("CC1746")
    Range("F3:F85").Copy Range("CC1829")
    Range("J3:J85").Copy Range("CC1912")
    Range("N3:N85").Copy Range("CC1995")
    Range("R3:R85").Copy Range("CC2078")
    Range("V3:V85").Copy Range("CC2161")
    Range("Z3:Z85").Copy Range("CC2244")
    Range("AD3:AD85").Copy Range("CC2327")
    Range("AH3:AH85").Copy Range("CC2410")
    Range("AL3:AL85").Copy Range("CC2493")
    Range("AP3:AP85").Copy Range("CC2576")
    Range("AT3:AT85").Copy Range("CC2659")
    Range("AX3:AX85").Copy Range("CC2742")
    Range("BB3:BB85").Copy Range("CC2825")
    Range("BF3:BF85").Copy Range("CC2908")
    Range("BJ3:BJ85").Copy Range("CC2991")
    Range("BN3:BN85").Copy Range("CC3074")
    Range("BR3:BR85").Copy Range("CC3157")
    Range("BV3:BV85").Copy Range("CC3240")
    Range("BZ3:BZ85").Copy Range("CC3323")
    Range("C3:C85").Copy Range("CD1746")
    Range("G3:G85").Copy Range("CD1829")
    Range("K3:K85").Copy Range("CD1912")
    Range("O3:O85").Copy Range("CD1995")
    Range("S3:S85").Copy Range("CD2078")
    Range("W3:W85").Copy Range("CD2161")
    Range("AA3:AA85").Copy Range("CD2244")
    Range("AE3:AE85").Copy Range("CD2327")
    Range("AI3:AI85").Copy Range("CD2410")
    Range("AM3:AM85").Copy Range("CD2493")
    Range("AQ3:AQ85").Copy Range("CD2576")
    Range("AU3:AU85").Copy Range("CD2659")
    Range("AY3:AY85").Copy Range("CD2742")
    Range("BC3:BC85").Copy Range("CD2825")
    Range("BG3:BG85").Copy Range("CD2908")
    Range("BK3:BK85").Copy Range("CD2991")
    Range("BO3:BO85").Copy Range("CD3074")
    Range("BS3:BS85").Copy Range("CD3157")
    Range("BW3:BW85").Copy Range("CD3240")
    Range("CA3:CA85").Copy Range("CD3323")
    Range("D3:D85").Copy Range("CE3")
    Range("H3:H85").Copy Range("CE86")
    Range("L3:L85").Copy Range("CE169")
    Range("P3:P85").Copy Range("CE252")
    Range("T3:T85").Copy Range("CE335")
    Range("X3:X85").Copy Range("CE418")
    Range("AB3:AB85").Copy Range("CE501")
    Range("AF3:AF85").Copy Range("CE584")
    Range("AJ3:AJ85").Copy Range("CE667")
    Range("AN3:AN85").Copy Range("CE750")
    Range("AR3:AR85").Copy Range("CE833")
    Range("AV3:AV85").Copy Range("CE916")
    Range("AZ3:AZ85").Copy Range("CE999")
    Range("BD3:BD85").Copy Range("CE1082")
    Range("BH3:BH85").Copy Range("CE1165")
    Range("BL3:BL85").Copy Range("CE1248")
    Range("BP3:BP85").Copy Range("CE1331")
    Range("BT3:BT85").Copy Range("CE1414")
    Range("BX3:BX85").Copy Range("CE1497")
    Range("CB3:CB85").Copy Range("CE1580")

    Thanks in advance
    Last edited by POPSS; 01-28-2025 at 02:05 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lags and Database Errors
    By sourabhg98 in forum Suggestions for Improvement
    Replies: 7
    Last Post: 02-25-2016, 06:27 AM
  2. Excel Workbook Lags
    By Hyperdude in forum Excel General
    Replies: 5
    Last Post: 11-12-2012, 03:27 AM
  3. Listbox lags when I scroll up and down
    By gazza365 in forum Excel General
    Replies: 0
    Last Post: 01-23-2011, 07:00 PM
  4. Performance issues, program lags before executing
    By cultavix in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2008, 07:32 PM
  5. Autosave lags in Excel 2007
    By AndrewPace in forum Excel General
    Replies: 2
    Last Post: 07-22-2007, 01:58 PM
  6. Workbook w/ macros lags or freezes when opened
    By macsrule1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2007, 02:47 AM
  7. Send to Mail Recipient (as attachment) Lags
    By JGas in forum Excel General
    Replies: 0
    Last Post: 02-09-2005, 03:06 PM

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