Question

what is the difference between a name with workbook and one with worksheet scope​

Answer 1

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.