3. Pros and cons of using named variables
Pros |
Cons |
|---|---|
| Makes formulas easier to understand | Have to be careful not to use the same name in different worksheets as this can be very confusing |
| A named variable can also reference a cell in another worksheet without the formula looking any different | Should pick sensible names - creating a name called 'UUUU' is probably not very helpful |
| Simple to move a variable to another location without any formulas being changed |