← Guides

Beginner Guide to Excel VBA Macros

Enable Developer

File → Options → Customize Ribbon → check Developer.

Record a macro

1. Developer → Record Macro
2. Name it (no spaces)
3. Do the steps → Stop Recording
4. Alt+F11 to view code

Security & runtime errors

• Macro blocked
• Runtime 1004
• Type mismatch 13
• Object required

Error directory