Posted to microsoft.public.excel.programming

Jim[_76_]

external usenet poster

Posts: 3

Using Solver in VBA in a loop

I have used Solver in VBA to solve optimization problems with good
results.
HOWEVER, when I tried to use it in a Monte Carlo For-Next loop, the
debugger highlights the 1st Solver function call.
So here are my questions:
1) Is it possible to execute Solver in a "For-Next" or other loop?
2) Has anyone tried anything similar?
Thanks,
Jim

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003	Duke Carey	Excel Programming	3	November 20th 07 03:48 PM
Need advice on Solver loop	robs3131	Excel Programming	1	October 10th 07 06:35 PM
Interesting Solver problem (Solver encounters an error)	MrShorty	Excel Discussion (Misc queries)	3	December 22nd 05 10:52 PM
Automating Solver in loop	msuryexcel	Excel Programming	2	October 18th 05 03:24 PM
Error message when using the Solver in a VBA macro loop	Mathieu Fournier	Excel Programming	2	March 1st 05 02:36 PM

All times are GMT +1. The time now is 06:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us