Range Names : Good or Bad programming practice?

[Bob Phillips]

If a cell changes you only make that change in one place

"Immeasurably better" is over the top. For some people they make it easier to read - others have no idea how to edit them and prefer a VLOOKUP. Range Names are not just a tool for the user, they are there for anyone who uses your workbook.

If they don't know what they are doing they should not mess with it. If they do, the consequences are on their shoulders.

On a more pedantic point why would you bother range naming that a one-off VLOOKUP?

I might agree with you about that being pedantic, if only I understood what you meant by the tail-end of that sentence.

Which for the same reason may protect formulas for er .. witting users

I was amazed to find that witting is actually in the dictionary , but I get your drift. But by definition, a witting user would know about that.

No. Its counter intuitive and a dangerous default

Just have to agree to disagree on that.

You and me are going to have fun .