XL: GP Fault/Hang Using Range of Cells in Function Procedure (121324)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 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
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | KB121324 |
|---|
|