SOLVER Syntax Help

**afrausin** · 02-15-2011, 01:00 PM

I'm working with the SOLVER addin in excel. I'm trying to enter a loop and an if statement in the follwoing VBA syntax:

SolverOk SetCell:="$T$24", MaxMinVal:=2, ValueOf:="0", ByChange:=" I would like to enter here a loop and an if statement so that I can select the cells I'm interested in "
SolverAdd CellRef:="$B$25", Relation:=2, FormulaText:="0"
SolverSolve userFinish:=True

Any help would be appreciated!

Thanks,
Augusto

**shg** · 02-15-2011, 01:12 PM

Welcome to the forum.

I think you need to provide a little more information about what you're trying to do.

Also, please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

**afrausin** · 02-15-2011, 01:37 PM

Thanks for the welcome and sorry if I was not clear in my question!

I am trying to dynamically select the cells in the ByChange function. I think the way to do it is to (1) define the range:

Please Login or Register  to view this content.

and (2) insert that range in the ByChange function:

Please Login or Register  to view this content.

if this is the right syntax, how do I set Rng to all cells within the matrix A1:D5 that are > 0?

Thank you!
Augusto

**shg** · 02-15-2011, 02:22 PM

Maybe like this:

Please Login or Register  to view this content.

SOLVER Syntax Help

LinkBack

Thread Tools

Rate This Thread

Display

SOLVER Syntax Help

Re: SOLVER Syntax Help

Re: SOLVER Syntax Help

Re: SOLVER Syntax Help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions