Code runs fine for me. If B17 is involved in the calculation of the
formulas, then it seems setting it to "" would change the values being
returned by B15 and B16.

If you are just using rnd to stimulate a calculation (and it (B17) isn't
referenced by the formula), you can just use ActiveSheet.CalculateFull in
Excel 2000 and later

If the calculations are returning floating point numbers, it is probable
that they will never return equal numbers.

--
Regards,
Tom Ogilvy

"mrmark " wrote in message
...
Ok I have written some of my own code and I dont know if it works or not
because I get the "That name is not valid" box when I call the macro.
but heres the code
Sub numberct()
'
' numberct Macro
' Macro recorded 6/22/2004 by y98
'

'
If Range("B15") < Range("B16") Then
Range("B17") = Int(Rnd() * 0.009)
ElseIf Range("B15") = Range("B16") Then
Range("B17") = ""
End If

End Sub


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