How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004

by

.Formula accepts formulas in English.
Parameter separator in English is ,.

If you want to use formulas in the language of your Excel installation, use .FormulaLocal.

However to ensure your code will run on any Excel, fix your formula to be in accordance with the en-us locale.

More Related Contents:

  1. Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
  2. Excel Number Separation [closed]
  3. Excel formula checklist in employees
  4. Sequence of numbers based on start and end value of 2 cells [closed]
  5. Error in finding last used cell in Excel with VBA
  6. Excel VBA – How to add dynamic array formula
  7. Filling any empty cells with the value above
  8. Find last used cell in Excel VBA
  9. Count unique values in Excel
  10. Concatenate column headers if value in rows below is non-blank
  11. Countif With Multiple OR Criteria
  12. How to extract text within a string of text
  13. How to roundup a number to the closest ten?
  14. Save excel file multiple times with file names in another workbook.
  15. Read/Parse text file line by line in VBA
  16. How do I find the last column with data?
  17. Excel VBA: Answer gets “stuck”
  18. filter out multiple criteria using excel vba
  19. Excel VBA autofilter all but three
  20. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  21. Excel VBA code to copy a specific string to clipboard
  22. Excel VBA – Range.Copy transpose paste
  23. What does — do in Excel formulas?
  24. Refreshing all the pivot tables in my excel workbook with a macro
  25. Vlookup to copy color of a cell
  26. How to delete rows in Excel based on criteria using VBA?
  27. Macro to export MS Word tables to Excel sheets
  28. Create folder path if does not exist (saving from VBA)
  29. Concatenate multiple ranges using vba
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment