XL2000: OFFSET Worksheet Function Accepts Invalid Arguments (215275)


The information in this article applies to:

  • Microsoft Excel 2000
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 OFFSET()worksheet function, the function returns the same value as if +1 had been entered. The expected return is the following Excel error:

#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.

REFERENCES

For more information about the OFFSET() worksheet function, click Microsoft Excel Help on the Help menu, type offset in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB215275
©2003 Microsoft Corporation. All rights reserved.