XL5: GP Fault Using Intersection of Named Ranges in Function

• Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel, when you enter intersecting cell ranges in a user- defined function, using defined names for the ranges, you receive a general protection (GP) fault.

CAUSE

You receive the GP fault if the function is a Visual Basic function. You do not receive a GP fault if you enter the intersection of named ranges in a built-in function, or a Microsoft Excel version 4.0 macro function.

WORKAROUND

To avoid receiving a GP fault when you enter an intersection of ranges in a user-defined function, reference the intersection of ranges using the cell references, instead of the named ranges. For example, in the user-defined function Test, enter the intersection of cell ranges using the following formula:

   =Test(A1:A4 A4:D4)

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c for Windows.

MORE INFORMATION

Use a space (the intersection operator) to refer to the intersection of two or more cell ranges. For example, the following formula

   =A1:A4 A4:D4

REFERENCES

For more information about Referring To Intersecting Cell Ranges, choose the Search button in Help and type:

   intersection of ranges