# solving equations

1. ## solving equations

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.

2. ## Re: solving equations

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...

3. ## Re: solving equations

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.

4. ## Re: solving equations

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.

5. ## Re: solving equations

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.

6. ## Re: solving equations

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1