+ Reply to Thread
Results 1 to 6 of 6

The code run slowly !

  1. #1
    Registered User
    Join Date
    10-20-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2007
    Posts
    82

    The code run slowly !

    Hi, Experts

    i have try a code looking like Vlookup to compare two worksheet data but it was run more than 40 minutes ? which was i should changed? ... pls help
    Please Login or Register  to view this content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: The code run slowly !

    This wouldn't improve speed, but seems like you are using the wrong variables?
    Please Login or Register  to view this content.
    should be
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    10-20-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: The code run slowly !

    Quote Originally Posted by millz View Post
    This wouldn't improve speed, but seems like you are using the wrong variables?
    Please Login or Register  to view this content.
    should be
    Please Login or Register  to view this content.
    Oooh ... Thank you.. i try.

  4. #4
    Registered User
    Join Date
    10-20-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: The code run slowly !

    Might huge data caused (more than 20000 rows ) so any suggested which way i can get faster.

  5. #5
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: The code run slowly !

    Try this see if it makes any difference
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-20-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: The code run slowly !

    Quote Originally Posted by millz View Post
    Try this see if it makes any difference
    Please Login or Register  to view this content.
    Thanks very much, it's good for me .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code running slowly
    By Sweepin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2013, 09:15 PM
  2. [SOLVED] Working MUltifindreplace code very slowly
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2013, 03:21 AM
  3. [SOLVED] Code running slowly any way of speeding up processing time
    By boomboomblock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2013, 09:09 AM
  4. Code running slowly
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-01-2011, 11:08 AM
  5. [SOLVED] Paste code running extremely slowly...
    By KR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2005, 11:05 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