Microsoft KB Archive/184110

= XL98: OFFSET May Accept Negative Values for Height and Width =

Article ID: 184110

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184110





SYMPTOMS
When you use the OFFSET worksheet function and type a negative number for the Width argument or Height argument, you receive a result and not an error value. This behavior is incorrect.

If the Width argument or the Height argument is less than -1 (-2,-3,-4, and so on), the result of the OFFSET function is the error value #VALUE! unless you enter the formula as an array formula. When you enter the formula as an array, you receive a result and not an error value. This behavior is also incorrect.

NOTE: To enter a formula as an array formula in Microsoft Excel for the Macintosh, type the formula and press COMMAND+ENTER.



WORKAROUND
To work around this problem, use a positive integer number for the Width argument and the Height argument of the OFFSET worksheet function.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.



MORE INFORMATION
According to Microsoft Excel Help, the OFFSET worksheet function requires that the Width argument and the Height argument be a positive number.

