|
|
|
|
#1
07-22-2015, 12:22 AM
|
||||
|
||||
You could probably speed things up further by starting your macro with:
Application.ScreenUpdating = False Application.Calculation = xlCalculationManual and ending it with: Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic
__________________
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