excel-vba 472

  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. Excel VBA - exit for loop
  10. What is the difference between .text, .value, and .value2?
  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. How do I declare a global variable in VBA?
  15. Function to convert column number to letter?
  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. automatically execute an Excel macro on a cell change
  21. How to merge rows in a column into one cell in excel?
  22. How do I put double quotes in a string in vba?
  23. How to pause for specific amount of time? (Excel/VBA)
  24. What is the equivalent of “!=” in Excel VBA?
  25. How can I refresh all the pivot tables in my excel workbook with a macro?
  26. Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn't?
  27. How to suppress Update Links warning?
  28. Save each sheet in a workbook to separate CSV files
  29. How to add a reference programmatically
  30. Check if the file exists using VBA
  31. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  32. Determining the full type of a variable
  33. Test or check if sheet exists
  34. What does the Excel range.Rows property really do?
  35. What is the difference between dim and set in vba
  36. How to put a tooltip on a user-defined function
  37. “Can't find Project or Library” for standard VBA functions
  38. Refresh Excel VBA Function Results
  39. How can I URL encode a string in Excel VBA?
  40. Convert cells(1,1) into “A1” and vice versa
  41. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  42. Excel function to make SQL-like queries on worksheet data?
  43. Way to run Excel macros from command line or batch file?
  44. Excel column number from column name
  45. Using a UDF in Excel to update the worksheet
  46. Iterate over VBA Dictionaries?
  47. Excel Macro : How can I get the timestamp in “yyyy-MM-dd hh:mm:ss” format?
  48. How to use the Implements in Excel VBA
  49. How can I find last row that contains data in the Excel sheet with a macro?
  50. How to protect cells in Excel but allow these to be modified by VBA script