+ Reply to Thread
Results 1 to 5 of 5

Cell calculation not responding?

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Cell calculation not responding?

    Hi,

    I have a simple calculation which has worked in the past but seems to have stopped working. I was advised to paste
    Please Login or Register  to view this content.
    in the intermediate window which kick started the program but
    I require greater reliability. I've checked the target cells and everything looks fine. Can anyone see whats up?




    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    423

    Re: Cell calculation not responding?

    You've set Application.EnableEvents = False at the top of the module. It will stay that way until you set it to true (or restart Excel). Using the Immediate Window is perfectly fine for debugging, but you've got to fix the code too, by putting Application.EnableEvents = True at the end of the module.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Cell calculation not responding?

    Hi,

    The way that code is written, it will test N13 against all of those values, even after matching one of them. I'd suggest this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Cell calculation not responding?

    Thanks Lads, sorry for delay, up to my neck this morning. I'll examine code now, Thanks

  5. #5
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Cell calculation not responding?

    All sorted. Thanks you for your help :-)

+ 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] Not Responding
    By jaywenzel in forum Excel General
    Replies: 8
    Last Post: 08-28-2012, 07:39 PM
  2. [SOLVED] Add an amount from a calculation to a cell with a calculation (Sample attached)
    By aiwnjoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2010, 10:41 AM
  3. Worksheet change event not responding to cell deletion
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2008, 06:30 PM
  4. Worksheet change event not responding to cell deletion
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2008, 03:22 PM
  5. Macro not responding to cell deletion
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2008, 02:29 PM
  6. Worksheet_Change macro not responding to cell deletion
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2008, 09:05 PM
  7. one cell responding to data from another cell
    By cadman13 in forum Excel General
    Replies: 2
    Last Post: 02-01-2007, 12:00 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