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)))"""
See Question&Answers more detail:osThe 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)))"""
See Question&Answers more detail:os