Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I have the following formula B29*(B31-G34)^2/2 =0 Values in B29 and B31

are constant I need to

write a VBA code to unable me to find the Value of G34 so that the formula =0

any one can help

Your formula is

B29*(B31-G34)^2/2 =0

This would be calculated in this order

B31-G34

^2

/2

*B29

=0

If that is what you meant

Then for the equation to = 0, B31 and G34 must be equal. It does not matter

what B29 is.

If you meant something else, let us know what you did mean, including the

order of calculation.

Didn't find what you were looking for?
Find more on loop in VBA
Or get search suggestion and latest updates.

Related Topics:

- Setting UserForm captions via VBA loop
- vba loop
- Looped VBA to paste special values
- to loop or not to loop
- program using while loop and for loop
- Placing VBA Code "Live" Into Another WkBook Via VBA
- Convert code from excel 2000 vba to excel 2003 vba
- writing vba code to generate vba code
- Cannot use the VBA add table command of MS word in MS Excel VBA
- Cannot use the VBA add table command of MS word in MS Excel VBA
- writing vba code to generate vba code
- Add-Ins loaded into Excel
- Loop macro in Excel
- Stopping Infinite Loops
- Loop in formula
- how to ingreement the loop value automaticaly still last regards
- Populate array value using For Next loop
- If and loop
- Loop macro in Excel
- trouble with IF/OR, Left and a simple loop
- Going loopy with loops
- Help with "Nested Do While Loop"
- Help with Loops
- loop thorugh a column and copy to matching workbook
- Nested For Loop Plz Help