VBA
-
5 ways to use the VBA Immediate window in Excel
-
8 VBE tips every programmer should know
-
A common mistake when declaring variables in VBA
-
A VBA coding manifesto
-
Add description to a custom VBA function
-
Automatically create a Table of Contents in Excel
-
Coding best practices using VBA for Excel
-
Count cells with text and formula – Excel stats
-
Determine the drive, folder & file existence (VBA functions)
-
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
-
Learn top 10 Excel features
-
Like operator
-
Pausing or delaying VBA using Wait, Sleep or a loop
-
Proper VBA error handling
-
Resetting the Last Cell in an Excel worksheet
Page 1 of 2