A 2-D named range references the same cell or range of cells across multiple worksheets in a workbook.

Name: A 2-D named range references the same cell or range of cells across multiple worksheets in a workbook.
Brand: Quizplus
Rating: 4.7 (35 reviews)

Question

Quizplus · Accepted Answer

A 2-D named range actually refers to creating a name that can be used to refer to the same cell or range of cells on multiple sheets, but it does not reference the same cells across those sheets by default. Each sheet can have different values in the same cells that are part of the 2-D range.

A 2-D Named Range References the Same Cell or Range