+ Reply to Thread
Results 1 to 5 of 5

Run goal seek if values are changed and avoiding unlimited loops

  1. 08-24-2009, 03:26 PM #1
    Operator
    Operator is offline
    Registered User
    Join Date
    08-20-2009
    Location
    Auburn, AL
    MS-Off Ver
    Excel 2003
    Posts
    14

    Run goal seek if values are changed and avoiding unlimited loops

    Hi!
    I am trying to activate the goal seek function if the goal cell is not the same as the indirect solution to the function the goal seeker solves. The goal seeker activates but every time it solves the formulas it also makes my excel crash about 10 secondas afterwards.
    I am aware that the solution is not exactly the same as the targeted solution but I don't know any good ways to make this happen just only once. 


    Please Login or Register  to view this content.

    I have trade to change the if to 

    Please Login or Register  to view this content.
    but no good results so far

    Best Regards

    E
    Last edited by Operator; 08-24-2009 at 03:30 PM.
    Reply With QuoteRegister To Reply
  2. 08-24-2009, 03:42 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Run goal seek if values are changed and avoiding unlimited loops

    Pretty brutal running this every time anything is changed on the sheet.
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 08-24-2009, 05:02 PM #3
    Operator
    Operator is offline
    Registered User
    Join Date
    08-20-2009
    Location
    Auburn, AL
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Run goal seek if values are changed and avoiding unlimited loops

    Yes it is. That is suppose to be changed. But since I haven't figured out how to make make a loop that checks every value for each cell I will make use make the macro so that it will start if like one of 8 cells are changed instead of those 91-8. Those eight cells are sums of the 91-8 which means that I need to have that brutal loop inside if I stick with my suggested and ugly solution.
    Reply With QuoteRegister To Reply
  4. 08-25-2009, 10:52 AM #4
    Operator
    Operator is offline
    Registered User
    Join Date
    08-20-2009
    Location
    Auburn, AL
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Run goal seek if values are changed and avoiding unlimited loops

    I have tried to erase the 8 to 91 every time something changes but the slowness is still there. There must be because of something else. Is there a way to do this a bit more inexact?

    Please Login or Register  to view this content.
    ... goalseek

    Best Regards

    E
    Reply With QuoteRegister To Reply
  5. 08-25-2009, 10:56 AM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Run goal seek if values are changed and avoiding unlimited loops

    Did you try the code I posted?
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1