VBA Blog Series

Here is a complete list and respective links to all of our VBA blogs:

1. Introduction to VBA
2. Introduction to VBA: Recording Macros
3. Introduction to VBA – Reading Code
4. Adapting recorded macros – Range Names
5. Cleaning Up Recorded Macros
6. Using Message Boxes in Excel
7. Updating your Status (Bar) in Excel
8. If I use VBA Then I get better at it!
9. Declaring Variables
10. For Loops
11. Unhiding and Unprotecting Sheets
12. Handling VBA Errors
13. Speeding up the Pace of Running Your Macros
14. Hidden vs Very Hidden
15. An Eventful Month Coming up!
16. Save the event!
17. Painting with Excel
18. DoEvents
19. Referring to Ranges
20. Range Modifiers
21. The Value of Declaring Variables
22. Scoping Variables
23. Constants is Her Name
24. Unforget-TABLE, That’s What You Are
25. Turning Tables
26. Close Range
27. DataBodyRange Part 1
28. DataBodyRange - New Frontier
29. Header-ache
30. Total Eclipse of the Heart
31. ListColumn
32. ListColumn Swan Song
33. Same Same But Different
34. Having a Row
35. Can't Row with a Column
36. Getting Loopy Each Time
37. Wending down the hill Until you Do
38. 'Do' You Want To 'Exit'?
39. At Least Once in Our Lives, Let’s 'Do' It!
40. 'Do' it 'Until' You Believe
41. Lost and Found
42. After You
43. Looking Up and Down
44. Digging Up
45. Finding the Part of a Whole
46. Matching the Case
47. Find The Right Format
48. Op-TRIM-isation
49. Stop Reticulating Splines! - Part 1
50. Stop Reticulating Splines - Part 2
51. Going Through the Visual Basics – Part 1
52. Going Through the Visual Basics – Part 2
53. Going Through the Visual Basics – Part 3
54. Going Through the Visual Basics – Part 4
55. Going Through the Visual Basics – Part 5
56. Going Through the Visual Basics – Part 6
57. Going Through the Visual Basics – Part 7
58. Going Through the Visual Basics – Part 8
59. Going Through the Visual Basics – Part 9
60. Going Through the Visual Basics – Part 10
61. Going Through the Visual Basics – Part 11
62. Going Through the Visual Basics – Part 12
63. Going Through the Visual Basics – Part 13
64. Going Through the Visual Basics – Part 14
65. Going Through the Visual Basics – Part 15
66. Going Through the Visual Basics – Part 16
67. Going Through the Visual Basics – Part 17
68. Going Through the Visual Basics – Part 18
69. ActiveWorkbook.Saved = True vs AutoSave
70. Selecting The Right Case
71. Select Case Flexibility
72. Selecting Case By Case
73. Charts and Macros
74. Charts and Macros 2
75. Charts and Macros 3
76. Charts and Macros 4
77. Common Traps 1
78. Common Traps 2
79. Common Traps 3
80. Common Traps 4
81. Referring to Sheets
82. Shape References
83. File Path Selector
84. File Path Selector confined to CSV
85. Create text file from Excel table
86. Group Specific Rows
87. Dynamically Highlight the Row
88. Dynamically highlight entire row and column
89. Dynamically Highlight the Entire Row and Column by Using VBA Script
90. Multiple Criteria Filter
91. Deleting Specific Rows
92. Dynamic Validation List
93. Deleting Error Values
94. Copy Values from Discontinuous Ranges to Specific Ranges

This list will be updated accordingly!