VBA
-
8 VBE tips every programmer should know
-
A VBA coding manifesto
-
Coding best practices using VBA for Excel
-
Do you have to use Dim to declare variables?
-
Excel VBA best practices – coding standards – variables
-
Excel VBA dictionary – A complete guide
-
How to deal with real world VBA code
-
How to reduce VBA errors by up to 70%
-
How to use Regular Expression for data validation in Excel 2010
-
Remove empty sheets
-
Resetting the Last Cell in an Excel worksheet
-
Scrub your data expressively
-
The complete guide to using arrays in Excel VBA
-
The great Hungarian debate
-
The ultimate guide to loops in Excel VBA
-
The ultimate guide to using strings in Excel VBA
-
The VBA guide to ListObject Excel tables
-
VBA best practices that I'll never do
-
VBA Class modules – The ultimate guide
-
VBA error handling – A complete guide
Page 1 of 2