Jun 04 2023 08:23 AM
Have not used this new feature very much, it was on my system then it was gone for a long time, just now figured out how to get it back. I'm trying to make some dynamic named ranges, using offset and counta in the formula. Its nice to edit long formulas in this editor.
My problem is, when you make a named range, in excel you have the option to limit the scope of the named range to a worksheet, instead of a work book. WHERE is this option in EL-Adv From Editor? It's probably something simple but i'm missing it. Thanks.!
Jun 04 2023 09:10 AM
@EG1165
AFE doesn't support sheet-scope names. Question is opened here There is no option to change the scope of the range · Issue #40 · microsoft/advanced-formula-environ..., you may add your reasons to AFE team.