New to macros.....

I'm trying to convince an engineer that there are many possibilities t
a tolerance stackup.

Cells A1:A10 are nominal dimensions. The value doesn't matter.

Cells B1:B10 are all randomly generated plus values from .001 to .060.

Cells C1:C10 are all randomly generate minus values from -.001 t
-.060.

Cell C11 is sum(B1:C10).

What I do is hit F9 until my arm falls off until C11 is .030.

That's what the engineer is looking for over 10 dimensions, .030.

I want a macro to calculate until C11 = .030

I'm trying to show that there are many possibilities.

I read the Visual Basic help pages for hours but defer to you, th
experts.

What I have started with is:

Sub Regen()
If C11 < .030 Then
Calculate
End If
End Sub

I know that won't work because it doesn't.

Thanks in advance

--
Message posted from http://www.ExcelForum.com