excel-vba 264

  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. Is there a way to crack the password on an Excel VBA Project?
  4. How to Return a result from a VBA Function
  5. Loop through files in a folder using VBA?
  6. Error in finding last used cell in VBA
  7. How Do I Convert an Integer to a String in Excel VBA?
  8. How can I send an HTTP POST request to a server from Excel using VBA?
  9. What is the difference between .text, .value, and .value2?
  10. Excel VBA - exit for loop
  11. How to get the path of current worksheet in VBA?
  12. Excel VBA App stops spontaneously with message “Code execution has been halted”
  13. Display milliseconds in Excel
  14. Function to convert column number to letter?
  15. How do I declare a global variable in VBA?
  16. How do I use FileSystemObject in VBA?

  17. Loop through each row of a range in Excel
  18. Break out of a While…Wend loop
  19. How to add a custom Ribbon tab using VBA?
  20. How to pause for specific amount of time? (Excel/VBA)
  21. What is the equivalent of “!=” in Excel VBA?
  22. How to suppress Update Links warning?
  23. How to merge rows in a column into one cell in excel?
  24. automatically execute an Excel macro on a cell change
  25. How do I put double quotes in a string in vba?
  26. Refreshing all the pivot tables in my excel workbook with a macro
  27. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  28. How to add a reference programmatically
  29. Test or check if sheet exists
  30. Save each sheet in a workbook to separate CSV files
  31. Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn't?
  32. Check if the file exists using VBA
  33. How can I URL encode a string in Excel VBA?
  34. How to put a tooltip on a user-defined function
  35. “Can't find Project or Library” for standard VBA functions
  36. Way to run Excel macros from command line or batch file?
  37. Determining the full type of a variable
  38. Convert cells(1,1) into “A1” and vice versa
  39. Refresh Excel VBA Function Results
  40. What does the Excel range.Rows property really do?
  41. What is the difference between dim and set in vba
  42. Excel column number from column name
  43. Progress bar in VBA Excel
  44. Excel Macro : How can I get the timestamp in “yyyy-MM-dd hh:mm:ss” format?
  45. How can I find last row that contains data in the Excel sheet with a macro?
  46. Excel function to make SQL-like queries on worksheet data?
  47. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  48. Detect whether Excel workbook is already open
  49. How to use the Implements in Excel VBA
  50. Using a UDF in Excel to update the worksheet