alexshahidi
New Member
- Joined
- Mar 19, 2002
- Messages
- 1
I am trying to set up something like Goal Seek in VBA so
that I can run the following calculation (which has been
simplified):
A1 = X
A2 = A1*100
A3 = 500
I want to write VBA code that will calculate "X" for A1 to
equal 5 (since X*100=500). I cannot rewrite the formula in
A1 because A2 is actually a combination of hundreds of
formulas. Also, I can't use Goal Seek. I need something
that will run random numbers until it finds a match. Any
ideas? Thanks.
that I can run the following calculation (which has been
simplified):
A1 = X
A2 = A1*100
A3 = 500
I want to write VBA code that will calculate "X" for A1 to
equal 5 (since X*100=500). I cannot rewrite the formula in
A1 because A2 is actually a combination of hundreds of
formulas. Also, I can't use Goal Seek. I need something
that will run random numbers until it finds a match. Any
ideas? Thanks.