Formula tab--> defined names

[lezawang]

Hi
Under formula tab, there is a command called "use in formula" then inside that there are 3 options: address, name and paste names. Any idea how to use these option and for what they are there?
Thank you.

 

[Scott Huish]

After trying it out, it allows you to pick from a list the named ranges and either use it in a formula or put a list of the named ranges and their corresponding references onto the sheet.