Forum Discussion
using a formula to name a range
I would like to base the name of a range on the contents of another cell. The cell it will be named after just has text in it. Essentially I want the name of the group of cells to be "=A2" where A2 wo...
joshman81 Not with a formula, but perhaps the "Create from selection", as described in the article link below is what you need.
Beware that Named ranges are bound to certain rules. The may not start with a number, contain spaces or other special characters. Such are preceded or replaced by underscores. So, if the cell with the name to be used contains John Doe, the named range will be called John_Doe . Similarly, a name like Doe, John will become Doe__Joe