I’ve been having trouble changing the scope (worksheet or workbook) of my MANY defined names. I’m not sure what determines the scope when I create the defined name.
If it gets a scope of worksheet, then I have to somehow change it to workbook, and it isn’t clear how to do that.
I read help and it answered all questions except how to change the scope of an existing name. Suggestions anyone?
Sid