2.1.1035 Part 1 Section 18.17.7.282, ROWS
a. The standard states that if the range of cells referred to by array is not contiguous, #NULL! is returned.
-
Office returns #REF!, if array refers to the union of discontiguous ranges.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
a. The standard states that if the range of cells referred to by array is not contiguous, #NULL! is returned.
Office returns #REF!, if array refers to the union of discontiguous ranges.