Different languages issue when inserting formula from VBA

by

VBA is very EN-US-centric. VBA’s .Formula and .FormulaR1C1 expect the ROW function. To use regional language function ‘flavors’ like СТРОКА then the Range.FormulaLocal property or Range.FormulaR1C1Local property should be employed instead.

The same holds true for list separator characters. Use a comma (e.g. ,) to separate the arguments in a function when using .Formula or .FormulaR1C1 regardless of system regional settings. If your system uses a semi-colon (e.g. ;) as the list separator character, this should only be used with .FormulaLocal or .FormulaR1C1Local.

The result on the worksheet will properly reflect the language settings of the Office installation.

myRange.Formula = "=ROW(mySheet!$12:$12)"
myRange.FormulaR1C1 = "=ROW(mySheet!R12)"
myRange.FormulaLocal  = "=СТРОКА(mySheet!$12:$12)"
myRange.FormulaR1C1Local= "=СТРОКА(mySheet!R12)"

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. Refer to sheet using codename
  4. VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds
  5. Assign code to a button created dynamically
  6. Last not empty cell (column) in the given row; Excel VBA
  7. HTML Text with tags to formatted text in an Excel cell
  8. Split comma separated entries to new rows [closed]
  9. Get list of Excel files in a folder using VBA [duplicate]
  10. Select first empty cell in column F starting from row 1. (without using offset )
  11. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  12. Excel VBA: AutoFill Multiple Cells with Formulas
  13. VBA.Find and adding a value
  14. excel vba- extract text between 2 characters
  15. Round function in Excel, worksheet function vs VBA
  16. How to continue the code on the next line in VBA
  17. How to create a separate CSV file from VBA?
  18. Excel VBA Userform – Execute Sub when something changes
  19. Count the number of rows in another sheet [duplicate]
  20. Getting Excel to refresh data on sheet from within VBA
  21. VBA Password Input with Cancel Function
  22. Finding first blank row, then writing to it
  23. Iterating through all the cells in Excel VBA or VSTO 2005
  24. Calling regasm without administrative rights for COM interop in Excel VBA
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  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