In HELP for the OFFSET function, it is stated that Height (and Width) must be positive numbers. Since the function seems to work with negative numbers for these arguments, merely reversing the direction of the range, one might think that this is a documentation
However, searching the MSKB reveals that this has been flagged as abnormal behavior, that Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
It seems this behavior has existed at least since
Microsoft Excel 5.0 !!! , so they are taking their time about fixing it :-)
I don't know if it is "a problem" in Excel 2010 but perhaps someone could let TPTB know that this is a useful feature.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
I hope you are correct. But given the kinds of things that MS has discontinued in the past, and the fact that this behavior is explicitly stated as being incorrect, I am not as sanguine as you. Especially if this "feature" gets broken in some future update,
I doubt that fixing it will have any kind of priority.
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
Last updated September 16, 2020