Mark in Boston
New Member
- Joined
- Aug 14, 2003
- Messages
- 18
A formula uses a named a range but it needs to be expanded. I have tried highlighting the range and renaming it but that does not work. Any ideas? Thanks
September 2017 and this is still helping - THANKS
Please note: if all the options are greyed out (un-selectable) when you open the 'Name Manager' on the Formulas tab, or use Ctrl+F3, it is because the sheet is protected. Once you un-protect the sheet you can proceed to make your changes as described above. HTH.