在Excel VBA中正确编写公式 [英] Write properly a formula in Excel VBA

问题描述

我以前已经问过这样的问题，但是似乎给出的答案在这种情况下不起作用

I already asked a question like this before, but seems that the answer given is not working in this case

这是我的代码:

Worksheets("Sheet").Range(myRange).formula = "=CONCATENATE(CODICI!" & stringCodiceCella & ";" & stringDesignazioneCella & ")"

请注意，stringCodiceCella是一个字符串，stringDesignazioneCella也是一个字符串.

Note that stringCodiceCella is a String, and stringDesignazioneCella is also a String.

点击此链接 VBA中公式的有效示例

我看不到错误.

推荐答案

您可以使用，"代替;"如@BigBen

You can use "," in place of ";" as suggested by @BigBen

Worksheets("Sheet").Range(myRange).Formula = "=CONCATENATE(CODICI!" & stringCodiceCella & "," & stringDesignazioneCella & ")"

或使用FormulaLocal

Worksheets("Sheet").Range(myRange).FormulaLocal = "=CONCATENATE(CODICI!" & stringCodiceCella & ";" & stringDesignazioneCella & ")"

参见下面的代码.

Worksheets("Sheet").Range(myRange).Formula = "=CONCATENATE(CODICI!" & stringCodiceCella & ",""-""," & stringDesignazioneCella & ")"

Worksheets("Sheet").Range(myRange).FormulaLocal = "=CONCATENATE(CODICI!" & stringCodiceCella & ";""-"";" & stringDesignazioneCella & ")"

这篇关于在Excel VBA中正确编写公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！