vba 471

  1. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  2. How to avoid using Select in Excel VBA
  3. How to comment and uncomment blocks of code in the Office VBA Editor
  4. Does VBA have Dictionary Structure?
  5. Where does VBA Debug.Print log to?
  6. How to Return a result from a VBA Function
  7. Difference between Visual Basic 6.0 and VBA


  8. Loop through files in a folder using VBA?
  9. Check if a string contains another string
  10. Error in finding last used cell in VBA
  11. What does the keyword Set actually do in VBA?
  12. Can I simultaneously declare and assign a variable in VBA?
  13. Excel VBA - exit for loop
  14. How to get the path of current worksheet in VBA?
  15. Excel VBA App stops spontaneously with message “Code execution has been halted”
  16. Microsoft Excel ActiveX Controls Disabled?
  17. Is VB really case insensitive?
  18. How do I declare a global variable in VBA?
  19. Deleting a file in VBA
  20. Declare and Initialize String Array in VBA
  21. When editing Microsoft Office VBA, how can I disable the popup “Compile error” messages?
  22. How do I use FileSystemObject in VBA?
  23. Break out of a While…Wend loop
  24. VBA - how to conditionally skip a for loop iteration
  25. How do you test running time of VBA code?
  26. How to pause for specific amount of time? (Excel/VBA)
  27. How to suppress Update Links warning?
  28. automatically execute an Excel macro on a cell change
  29. Hash Table/Associative Array in VBA
  30. Refreshing all the pivot tables in my excel workbook with a macro
  31. How to create and write to a txt file using VBA
  32. Test or check if sheet exists
  33. Save each sheet in a workbook to separate CSV files
  34. Good Patterns For VBA Error Handling
  35. VBA array sort function?
  36. How to parse XML using vba
  37. Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn't?
  38. Check if the file exists using VBA
  39. How can I URL encode a string in Excel VBA?
  40. How to put a tooltip on a user-defined function
  41. Parsing JSON in Excel VBA
  42. “Can't find Project or Library” for standard VBA functions
  43. Pass arguments to Constructor in VBA
  44. Way to run Excel macros from command line or batch file?
  45. Alternative IDE for VB6 and VBA
  46. Determining the full type of a variable
  47. Convert cells(1,1) into “A1” and vice versa
  48. Refresh Excel VBA Function Results
  49. What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?
  50. What does the Excel range.Rows property really do?