VBA code string to cell not working – run time error 1004

I’m trying to accomplish something very simple. Actually it used to run normally but when I changed to windows 7 + Office 2013 it just stopped working.

The following line in VBA won’t work:

  • Getting Values from other sheet in Excel using VBA
  • Excel get cell value from multiple workbooks
  • Download images from a CSV / XLS catalog
  • delaying excel calculations during interop C#
  • Count number of worksheets in Excel File
  • Selenium reading data from Excel file
  • Worksheets("Charts").Cells(2, 7) = "=" & "23,45" & "/PL!C" & 2
    

    Charts is an existent sheet of mine and PL is another existent sheet.

    If I add watch to the right hand side equation I get the following formula, which when pasted to the cell (manually) does work.

    =23,45/PL!C2
    

    The error I’m getting is:

    Run-time error '1004':
    Application-defined or object-defined error
    

    I’ve looked into several run time error 1004 questions but none of them seem to either be the same issue or work for me. Any ideas ? thanks

  • How to preserve source formatting while copying data from word table to excel sheet using VB macro?
  • How to make smart Manpower plan in HR field using Excel
  • Exporting Histogram from R to Excel
  • Select range avoiding empty rows or formatted
  • Changing Referenced Cell when Cell with Reference is changed
  • Excel VBA - in a list, if cell equals specific value then
  • One Solution collect form web for “VBA code string to cell not working – run time error 1004”

    Use the Range.Formula property with EN-US syntax or Range.FormulaLocal property with your regional locale settings.

    Worksheets("Charts").Cells(2, 7).FORMULA = "=" & "23.45" & "/PL!C" & 2
    Worksheets("Charts").Cells(2, 7).FORMULALOCAL = "=" & "23,45" & "/PL!C" & 2
    

    VBA is very EN-US-centric as providing translation for all regional settings ‘on-the-fly’ would create a large overhead.

    MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.