|
|
|
|
#1
07-21-2015, 02:23 PM
|
||||
|
||||
First off, why do you have two of:
Range("EY" & z).GoalSeek Goal:=Range("K" & z).Value, ChangingCell:=Range("EW" & z) As for the increase in time taken, that's probably because you're not giving the OS & Excel any housekeeping time. Try inserting the following into your loop: If i Mod 100 = 0 Then DoEvents
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
| Tags |
| goal seek, sample, vba code |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatic goal seek program-Help required | calltobala | Excel Programming | 0 | 05-08-2015 08:41 AM |
| Excel 2013, Problem with a shared file, takes long time to load and save and loads missing data | PStark | Excel | 0 | 12-04-2014 07:52 AM |
| Excel VBA Multiple Automatic Goal Seek Required – Please Assist us | champaben | Excel Programming | 13 | 06-22-2014 05:54 AM |
| set daily goal for actual workdays, excluding weekends holidays and days off | Brian Reilly | Excel | 1 | 01-24-2014 11:56 PM |
 Adding a goal line to a chart
|
uhlersa | Excel | 1 | 01-16-2012 08:18 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode