Ten useless VBA coding errors that must be terminated

Coders have long banned Hungarian notation from their VBA modules. It's meaningless when the code editor is slick enough to show information about a variable.

But now a new crop of equally meaningless, over-used coding errors have begun to litter code modules... and these need to go, too:

• Hungarian notation.
• Long Sub and Function procedures.
• Meaningless naming of variables and procedures.
• Using error handlers, just for the sake of it.
• Using comments, just for the sake of it.
• Not validating data.
• Too many parameters.
• Using magic values.
• Declaring variables incorrectly.
• Coding more than you have to.