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