2.1.1022 Part 1 Section 22.214.171.1242, 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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback