VBA:在方程式内使用&

Question

我想创建一个内部带有&的公式，但VBA认为它是一个连接符号

""&"“不起作用，还有别的窍门吗？

我的公式是：

Sheets("Elasticity").Cells(iRow, 38).Formula = "=SUMIFS(" & "All_Models!$W$2:$W$" & nrow & ",All_Models!$G$2:$G$" _ & nrow & ",Elasticity!L" & iRow & ",All_Models!$AL$2:$AL$" & nrow & ",Elasticity!AK" & iRow & _ ",All_Models!$B$2:$B$" & nrow & "," & "" <= "" & "&" & "ElasticityA" & iRow & ")"

我想要转变：

"" <= "" & "&" & "Elasticity!A" & iRow & ")"

进入：

"<="&Elasticity!A2)

Answer 1

这样如何：

dim s as string
s = "my_complicated_formula" & "&" & "and_another_formula"

Answer 2

s="foo" & Chr(38) & "bar"

其中chr(38) =&

Answer 3

...All_Models!$B$2:$B$" & nrow & ",""<=""&" & "Elasticity!A" & iRow & ")"