excel - Insert formula using VBA Dynamically

Question

asked Jan 31, 2022 in Technique[技术] by 深蓝 (71.8m points)

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:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

166 views

1 Answer

深蓝 · Answer 1 · 2022-01-31T07:16:12+0000

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?