GoalSeek

[ResolutionsNET]

Hi,

I'm looking for the Goalseek function from Excel in a VB function.

Any ideas where I can find it?

 

[ETID]

In the following, A1*b1=c1

so the end result too look for is 100 in c1 by changing the value of A1

-----------------

Sub GOAL_SEEK()
Range("C1&quot.GoalSeek Goal:=100, ChangingCell:=Range("A1&quot
End Sub

 

[ResolutionsNET]

Cheers, but I need the actual code for GoalSeek

 

[ETID]

I don't understand,..that sub is the code that will do goal seek as referenced to cells in a sheet..you can sustitute arrays for the hard values....or am I built too low?


x-)

 

[ETID]

X-)

 

[ResolutionsNET]

I want to replicate the functionality of GoalSeek from Excel into a Visual Basis function. Not VBA

 

[ETID]

Hmmmm, I'd try a math site ....looking for iliterations and solving for X

maybe something here?...just a guess

http://www.mathtools.net/