Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: OFFSET Worksheet Function Accepts Invalid Arguments

XL2000: OFFSET Worksheet Function Accepts Invalid Arguments

View products that this article applies to.

This article was previously published under Q215275

↑ Back to the top

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!

↑ Back to the top

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.

↑ Back to the top

Resolution

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

↑ Back to the top

Status

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB215275, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 215275
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 230