excel - Insert formula using VBA Dynamically

Question

The below VBA code is not inserting the code for dynamic formula.

sh.Range("bj" & 2 * i + 1).FormulaLocal = "=VALUE(TRIM(LEFT(E" & 2 * i + 1 & ", FIND("" - "",  E " & 
      2 * i + 1 & ") - 1)))"""

Answer 1

Please, try:

sh.Range("bj" & 2 * i + 1).FormulaLocal = "=VALUE(TRIM(LEFT(E" & 2 * i + 1 & ", FIND("" - "",  E" & 2 * i + 1 & ") - 1)))"

But do you have a function inside the above formula to be localized according to your language settings?