ExcelBanter - Name Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Name Range (https://www.excelbanter.com/excel-programming/351067-name-range.html)

ca1358

Name Range

Menu
Insert-Name-Define

List1 has a name of =#REF!$D$4:$D$4

In a Name Range, what does this mean

=#REF!$D$4:$D$4

cause the sample that I am looking at the range for List1 is B1:G1
--
ca1358

Chip Pearson

Name Range

It means that the worksheet to which the name referred has been
deleted.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ca1358" wrote in message
...
Menu
Insert-Name-Define

List1 has a name of =#REF!$D$4:$D$4

In a Name Range, what does this mean

=#REF!$D$4:$D$4

cause the sample that I am looking at the range for List1 is
B1:G1
--
ca1358

ca1358

Name Range

Thank you!!!!

--
ca1358

"Chip Pearson" wrote:

It means that the worksheet to which the name referred has been
deleted.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ca1358" wrote in message
...
Menu
Insert-Name-Define

List1 has a name of =#REF!$D$4:$D$4

In a Name Range, what does this mean

=#REF!$D$4:$D$4

cause the sample that I am looking at the range for List1 is
B1:G1
--
ca1358

All times are GMT +1. The time now is 03:39 PM.