solving equations

**hmasenger** · 03-03-2011, 08:19 AM

hi
i am writing a program which i need to solve a, 1 variable nonlinear equation for seveal times .it should be mentiond that i can abloulotly usethe solver add on but the problem is that i cant use it manuali for all my 300 time steps !! how can i solve thise 300 independent equtions automaticaly.
best regards.

**gill389** · 03-03-2011, 08:33 AM

Might want to post an excel dummy sheet so people can get a better picture of what your trying to do. Im not sure if you have to do the formula 300 times, if so you can just copy & paste it...

**hmasenger** · 03-03-2011, 08:40 AM

come on gill!!
is there any one who can copy te solver operation ?!!
there is a flood routing problem which i need to solve the equation for every single time step using the solver or goal seek .now the quastion is how can i use solver automaticali for this 300 time steps.

**shg** · 03-03-2011, 09:14 AM

You can automate Solver in VBA. You can start by recording a macro.

No one is going to be able to tell you anything specific to your requirement unless you do as gill suggested, and post a workbook that shows exactly what you're trying to do.

**hmasenger** · 03-04-2011, 02:20 AM

tnx shg
tis is the macro cde

Sub Macro3()
'
' Macro3 Macro
' gg
'

'
Range("K37").GoalSeek Goal:=1685.24, ChangingCell:=Range("J37")
Range("K39").GoalSeek Goal:=1636, ChangingCell:=Range("J39")
Range("K41").GoalSeek Goal:=1563.99, ChangingCell:=Range("J41")
ActiveWindow.SmallScroll Down:=-3
End Sub

as can be seen i need to use the goal seek more than this 3 time(over 200 times)
how can i use this solver ?pleas help i am totaly confused.

**shg** · 03-04-2011, 10:56 AM

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

Your code is implementing Goal Seek, not Solver.

If you are unable to post a workbook and explain what you're trying to do in context, I have no suggestions.