Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel solver newbie question
Hi,
When StepThru=true how excatly i get the cells which added as the left side of the constraints in the VBA function I can get them directly from the sheet(i hold a collection of cells) But is there away to get them from the solver? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel solver newbie question
Where go you want to "get them"
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... Hi, When StepThru=true how excatly i get the cells which added as the left side of the constraints in the VBA function I can get them directly from the sheet(i hold a collection of cells) But is there away to get them from the solver? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel solver newbie question
On Apr 22, 10:41 pm, "Bernard Liengme"
wrote: Where go you want to "get them" -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... Hi, When StepThru=true how excatly i get the cells which added as the left side of the constraints in the VBA function I can get them directly from the sheet(i hold a collection of cells) But is there away to get them from thesolver? Thanks in advance- Hide quoted text - - Show quoted text - I want to display all iterations values(at least the objective cell) on a chart. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel solver newbie question
I urge you to visit www.solver.com
Send them an email telling them you want to capture the values of the Target Cell (into a worksheet range) as Solver goes thru its iterations. I have had great luck getting advice from them best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... On Apr 22, 10:41 pm, "Bernard Liengme" wrote: Where go you want to "get them" -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... Hi, When StepThru=true how excatly i get the cells which added as the left side of the constraints in the VBA function I can get them directly from the sheet(i hold a collection of cells) But is there away to get them from thesolver? Thanks in advance- Hide quoted text - - Show quoted text - I want to display all iterations values(at least the objective cell) on a chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Simple excel question for newbie | Excel Worksheet Functions | |||
Excel Newbie Question Please Help | Excel Programming | |||
Newbie in Solver - please help | Excel Discussion (Misc queries) | |||
Newbie Question - Excel VBA | Excel Programming |