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

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

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.

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.