I followed your instruction. Thank you very much. The notes were perfect too.

- How may I save the results in another sheet? (Right now I can get the
results in the same sheet)

- May I put "IF statement" in Visial Basic part?
Because my iteration formulation is not very good. My Area results suppose
to obey 2 parameters. I could not put those 2 conditions in IF so, right now
iteration finds a value by using the first parameter, if it doesn't cover
second statement, then I manually change the formula in iteration and have it
solved the area according the second parameter. Even if the area result
doesn't cover the statements after using the second parameter then I say "for
this angle, there is no logical solution to myself" and I increase the Angle.

Since my "IF statement" in iteration is not very well prepared (my bad),
sometimes I may have to change couple of things in the formula. Each time I
change the formula, excel calculates the iteration of course. For every new
result, visial basic writes a new result as we(you) asked from it.

Since I can not make my IF statement in iteration better, maybe I could make
the visial basic part better by adding IF. So I was wondering if I may use IF
or WHEN statement in Visial Basic.

OR I may study IF AND statement in iteration part and try to fit my 2
conditions in my iteration(I am not sure if it will work) :)

It would be awesome if you may let me know how to have visial basic write
the results in another sheet.

Thank you very very much.
I appreciate your help.

Regards
"JLatham" wrote: