Microsoft KB Archive/121324

= XL: GP Fault/Hang Using Range of Cells in Function Procedure =

Article ID: 121324

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c

-



This article was previously published under Q121324



SYMPTOMS
In Microsoft Excel, if you use a range of cells in a Visual Basic function procedure, you receive a general protection (GP) fault, or your system may hang.



CAUSE
This problem occurs if you use a function procedure to return a range of cells on a worksheet as an array, and the range of cells contains a volatile function, such as the RAND function. For example, this problem occurs if you use the function Test on a worksheet, where Test is the following function: Function Test(x) Test = x  End Function Your system stops responding if one of the cells that you use in the function contains a volatile function. If more than one of the cells contains a volatile function, you receive a GP fault.

NOTE: This is not a problem if you use a single cell in a function procedure, and the cell contains a volatile function.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

