Greetings - I've been asked to see if I can improve the performance of a worksheet using Goal Seek in VBA code. It's pretty simple however the Goal Seek call itself takes literally 2-3 seconds to return - not a big deal except this routine iterates through 20,000 - 30,000 rows adding up to more then 15 HOURS to run. Needless to say this is less then optimal.
Is there a way to utilize Goal Seek against multiple rows at once with better performance or is this just the nature of the beast? I've tried reducing time by setting certain application settings such as turning off screenupdating but still need a much more robust solution
Any insight would be greatly appreciated
Grant
Is there a way to utilize Goal Seek against multiple rows at once with better performance or is this just the nature of the beast? I've tried reducing time by setting certain application settings such as turning off screenupdating but still need a much more robust solution
Any insight would be greatly appreciated
Grant
