Microsoft KB Archive/117847

{|
 * width="100%"|

-

The information in this article applies to:


 * 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" refers to the intersection of the ranges A1:A4 and A4:D4, which is the value in the cell A4.