what is the difference between a name with workbook and one with worksheet scope
Answers
Answered by
0
Answer:
Using Worksheet Names
When using a workbook Defined Name in a formula, you simply use the name exactly as it has been defined. ... However, if you use a Defined Name in a formula that is scoped to a worksheet other than the one that it is scoped to, then you need to prefix the name with the worksheet name.
Similar questions