+ Reply to Thread
Results 1 to 3 of 3

Excel file hangs when code for checking data added

  1. 07-18-2018, 04:15 AM #1
    Dean Zuki
    Dean Zuki is offline
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Excel file hangs when code for checking data added

    Hi Expert,

    Please help to see below code. My Excel file hangs when code added for checking whether data exist at sheet "Registration List 2018". MsgBox dialog box keep on running. If I remove this line of code

    Please Login or Register  to view this content.
    the system work fine.

    Please Login or Register  to view this content.
    Last edited by AliGW; 07-18-2018 at 05:56 AM.
    Reply With QuoteRegister To Reply
  2. 07-18-2018, 05:49 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Excel file hangs when code for checking data added

    The obvious answer would be to reduce your infinite ranges as they WILL slow things down, ie B:B and A:A maybe to something like B1:B10000 A1:A10000
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 07-18-2018, 09:47 PM #3
    Dean Zuki
    Dean Zuki is offline
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Re: Excel file hangs when code for checking data added

    Noted & thank you...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2016 file hangs on open
    By jonathanwsmith in forum Excel General
    Replies: 4
    Last Post: 04-23-2018, 12:52 PM
  2. excel hangs after giving File Open
    By Harpinator in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 12:40 PM
  3. [SOLVED] Excel hangs on opening file
    By Dee in forum Excel General
    Replies: 0
    Last Post: 02-15-2006, 12:20 PM
  4. [SOLVED] Excel 2003, XP hangs opening file on SSL
    By BN in forum Excel General
    Replies: 0
    Last Post: 01-31-2006, 03:35 AM
  5. Excel file hangs for several min, before opening
    By bill in forum Excel General
    Replies: 1
    Last Post: 08-31-2005, 03:05 PM
  6. [SOLVED] a certain excel file hangs up when i open it
    By dwightf1_ph in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 08:59 AM
  7. Code hangs Excel ... Why? ... and how can i debug??
    By Simon May in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1