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.
REFERENCES
For more information about the Function Statement, choose the Search button in the Visual Basic Reference and type:
function procedures
Additional query words: 5.00c gpf
Keywords: KB121324