Articles by Glen Alfaro

VBA Howtos

  1. How to Check if a File Exists Using VBA
  2. How to Use Excel VBA to Run SQL Query
  3. How to Use Try-Catch in VBA
  4. How to Print Output in the Immediate Window in VBA
  5. How to Get the Array Length in VBA
  6. How to Utilize Number Formats in Excel VBA
  7. How to Create and Utilize a Dictionary in VBA
  8. How to Declare and Initialize String Array in VBA
  9. How to Find a Value in a Column Using Excel VBA
  10. How to Sort the Elements of an Array and Arraylist in VBA
  11. How to Write Data to Text File Using Excel VBA
  12. Loops and Exit Loops in VBA
  13. How to Add Delay During Code Execution Using VBA
  14. How to Find the Last Row and Column in VBA
  15. How to Unlock VBA Password Using VBA Scripts
  16. How to Utilize Comments on VBA
  17. The Use of Function in VBA
  18. How to Check if a String Contains a Substring in VBA