The biggest giveaway of amateur VBA code is the excessive use of .Select and .Activate —a habit picked up from the macro recorder. Paul Kelly heavily advocates against this. Selecting cells slows down your code and causes the screen to flicker. Instead, his guides teach you to manipulate data directly in the background using object variables.
After nearly 20 years in software development—writing over a million lines of code for major insurance companies and car rental corporations—Paul Kelly noticed a recurring problem. Most Excel users were trying to learn VBA through dense, theoretical books or short, intense courses that left them unable to build actual, working tools. the excel vba handbook pdf paul kelly
Automating repetitive tasks across fixed numbers of rows or iterating through every worksheet in a workbook. The biggest giveaway of amateur VBA code is
What is your current (Absolute beginner, intermediate, or advanced)? Instead, his guides teach you to manipulate data
These are the types of real-world tasks you will master:
The "story" behind The Excel VBA Handbook Paul Kelly is one of a professional developer realizing that most people were being taught coding the wrong way. The "Light Bulb" Moment
Most Excel VBA books follow a painful pattern: Chapter 1 (What is a Macro?), Chapter 2 (The Range Object), Chapter 3 (Loops)... and by Chapter 4, you have abandoned the book to watch cat videos.