Glen Alfaro
VBA Howtos
- Check if a File Exists Using VBA
- Use Excel VBA to Run SQL Query
- Use Try-Catch in VBA
- Print Output in the Immediate Window in VBA
- Get the Array Length in VBA
- Utilize Number Formats in Excel VBA
- Create and Utilize a Dictionary in VBA
- Declare and Initialize String Array in VBA
- Find a Value in a Column Using Excel VBA
- Sort the Elements of an Array and Arraylist in VBA
- Loops and Exit Loops in VBA
- Write Data to Text File Using Excel VBA
- Add Delay During Code Execution Using VBA
- Find the Last Row and Column in VBA
- The Use of Function in VBA
- Unlock VBA Password Using VBA Scripts
- Utilize Comments on VBA
- Check if a String Contains a Substring in VBA