Microsoft KB Archive/215275

= XL2000: OFFSET Worksheet Function Accepts Invalid Arguments =

Article ID: 215275

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215275



SYMPTOMS
In Microsoft Excel, when you enter a value of -1 as the Height or Width argument in the OFFSETworksheet function, the function returns the same value as if +1 had been entered. The expected return is the following Excel error:


 * 1) VALUE!



CAUSE
This behavior occurs because the Height and Width arguments in the OFFSET worksheet function must be a positive number because Excel recognizes only the absolute value of the argument.



RESOLUTION
To resolve this issue, do not use negative values in the Height or Width argument of the OFFSET worksheet function.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

