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

ID: Q121324

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for Windows 95, version 7.0

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          : 
Version           : 5.00 5.00c 7.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: July 29, 1999