JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
If I define a named range that is the result of Offset, that name does not appear in the Name Box.
I assigned the name "Header" to B2. If I select B2, "Header" appears in the name box.
I then assigned the names V_1 & V_2 to B3 & B4 using Offset.
But these assigned names do not appear in the name box when selecting B3 or B4.
Also, why does the Name Manager show "{...}" for the value in these cells, rather than "V1" and "V2"?
I assigned the name "Header" to B2. If I select B2, "Header" appears in the name box.
I then assigned the names V_1 & V_2 to B3 & B4 using Offset.
But these assigned names do not appear in the name box when selecting B3 or B4.
Also, why does the Name Manager show "{...}" for the value in these cells, rather than "V1" and "V2"?