Software Salariman

Static variables in VBA functions, like their counterparts in C, retain their values between function calls. A common use for static variabl...

Excel supports both A1 and R1C1 notation for referencing cells in formulas. Almost everyone uses A1 notation but it can be easier to use R...

When writing VBA programs for Microsoft Excel 2003, you quickly find that you have to detect and handle run-time errors in your programs. V...

VBA doesn't have a ternary conditional expression (e.g. C-style ?: ), which leads to a long-winded conditional statement like this when ...