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

Show: