At first the Excel 2002 would crash if I would apptempt to audit and evaluate the array formula, though the formula might have the correct result. It crash frequently after I placed an ADO6.0 control on the userform. What's wrong with it?
Jack Zhong pretended : I was told that the application would not be stable if there were some ActiveX control on the sheet. It works fine after I removed ADO control.