Please note javascript is required for full website functionality.

VBA Blog Series

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!  

Newsletter