Solver: Macro to use for Mutiple Cells

[mona9254]

Hey I wrote a macro with solver and it will only work for that particular one... I need the macro to work from G42 to G246. Can someone please help me write one...Really appreciate it.

Please Login or Register  to view this content.

[nimrod]

I need the macro to work from G42 to G246.

What would you like the macro to do ?

[mona9254]

I want the macro to work on multiple cells, using the same solver formula but instead of just finding G41 I want to find the rest from G42 to G426., using the same relative cells( for each row). Im finding optimal price increase %.

[mona9254]

Do I need a loop in the macro to run the solver more than once??

[nimrod]

I'm not familiar with the "solver" ... if you could tell me what you are attempting to achieve I might be able to write you a procedure to accomplish the task.

[shg]

Welcome to the forum.

Post a workbook and explain in context?

Also, if you search the forum, there are many examples of automating Solver to work over multiple rows.

[mona9254]

Im getting a Compile Error: Expected End Sum and it is highlighting the first line Private Sub Worksheet_Activate(). How do I fix the problem

Please Login or Register  to view this content.