+ Reply to Thread
Results 1 to 3 of 3

changing copy and paste code to something more efficient

  1. #1
    Registered User
    Join Date
    11-13-2008
    Location
    Dunfermline, Scotland
    Posts
    25

    changing copy and paste code to something more efficient

    I have a macro that copies and pastes rows, depending on various conditions. The problem is, it takes ages, which in itself is fine, however during the running of it, I cannot copy and paste anything on any other application. Also I have heard that using copy and paste is not very efficient.

    Can anyone give me examples of how I could improve my code below?
    The 2nd example does update sheet 3, but the macro still runs.
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    Earth
    MS-Off Ver
    2016
    Posts
    694
    To look at improving efficiency, I'd need to look at your workbook; if you post it up I'll take a look at it for you. MM.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top left of thread.

  3. #3
    Registered User
    Join Date
    11-13-2008
    Location
    Dunfermline, Scotland
    Posts
    25
    I would love to post my spreadsheet however it's all data imports and macros, plus the actual workbook in it has lots of person identifying data in it.
    I have attached a scaled down version of the workbook and the only macro conerned is as follows (All my macros are in the PERSONAL.XLS file)
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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