Excel VBA Run-time error 1004 when inserting or value formula into cell

by

Inserting a formula with VBA requires that you use EN-US standards like,

Range("B64").Formula = "=INDEX(AK7:AK123, G74, 1)"

… or use the regional formula attribute like,

Range("B64").FormulaLocal = "=INDEX(AK7:AK123; G74; 1)"

You may have to also change INDEX to the regional equivalent. The latter is necessary when you have a system with regional settings that do not use the EN-US standard of a comma for a list separator.

see Range.FormulaLocal Property (Excel) for more information.

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Excel VBA deleting rows in a for loop misses rows
  4. What is the lifetime of a global variable in excel vba?
  5. Download attachment from Outlook and Open in Excel
  6. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  7. Embed picture in outlook mail body excel vba
  8. How to check for empty array in vba macro [duplicate]
  9. Use autofilter on more than 2 criteria
  10. What is the function of FormulaR1C1?
  11. Compiler Error: User-defined types not defined
  12. Open a workbook using FileDialog and manipulate it in Excel VBA
  13. Vba Excel do vlookup from a closed file
  14. excel hyperlink to nothing
  15. How to add headers to a multicolumn listbox in an Excel userform using VBA
  16. How to send files via HTTP_POST with Excel using VBA?
  17. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  18. How to Add Date Picker To VBA UserForm
  19. Vba macro to copy row from table if value in table meets condition
  20. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  21. Set a cell value from a function
  22. How to determine if a date falls on the weekend?
  23. What are the differences between using the New keyword and calling CreateObject in Excel VBA?
  24. Excel VBA wildcard search
  25. VBA Check if file (from website) exists
  26. Run-time error ’91’ (Object variable or With block variable not set)
  27. Loop through cells and add to a range
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment