Hi This is a question I incorrectly submitted earlier as a poll. So here it is in the correct format and thread.

**
I am currently trying to automate a spreadsheet which uses solver to determine the value of a cell. As with the code below I use input boxes to determine the value of the 'Set Target Cells', of the 'Cells to be changed' and of the 'Contraints'.

I already know what columns which will be selected before hand, and I have 150 rows which I want to run the optimizing function on separately.

TargetVal will always be in column B. ChangeVal will always be in M:V and DesiredVal will always be C:K.

Given I have 150 rows I want to run the solver function in all of them using a loop.

Can anyone please help/advise?


Thanks in advance!!!



Please Login or Register  to view this content.