i-nth - The great Hungarian debate

26 April 2014

This is an experiment in writing VBA code without using Hungarian notation.

I hated every minute of it. I hate reading it right now. I’ve struggled to pinpoint why it displeases me so, but I have a theory. It's hard to tell the difference between keywords and variables.

Full article: The great Hungarian debate

Connexion
VBA
Daily Dose of Excel
hungarian notation

Essential reading

Improving spreadsheet run time

Creating a slow spreadsheet is easy. Creating an efficient spreadsheet requires more thought and application of specific techniques.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.