blocks|key|414421|text|在这种情况下，要使用的正确字符是一个完整的冒号(:)，而不是分号(;)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|414422|entityMap^0|O|1|X|1|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

The correct character to use in this case is a full colon (<code>:</code>), not a semicolon (<code>;</code>).

blocks|key|416982|text|我不知道为什么，但如果你用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|416983|(...)Formula+=+"=SUM(D2,E2)"|code-block|syntax|javascript|416984|('，‘而不是';')，它可以工作。|offset|length|style|BOLD|416985|如果在VB脚本编辑器(F8)中单步执行sub，则可以将Range("F2").Formula添加到监视窗口，并从VB的角度查看公式的外观。似乎Excel中显示的公式有时与VB看到的公式不同……|CODE|416986|entityMap^0|0|0|2|1|8|1|0|R|J|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|T|8|@$I|U|J|V|K|L]|$I|W|J|X|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|Y|8|@$I|Z|J|10|K|O]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|Q|$]]

I don't know why, but if you use 

<pre><code>(...)Formula = "=SUM(D2,E2)"
</code></pre>

(',' instead of ';'), it works.

If you step through your sub in the VB script editor (F8), you can add <code>Range("F2").Formula</code> to the watch window and see what the formular looks like from a VB point of view. It seems that the formular shown in Excel itself is sometimes different from the formular that VB sees...

blocks|key|411225|text|您可以尝试使用FormulaLocal属性而不是公式。那么分号应该起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|411226|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can try using FormulaLocal property instead of Formula. Then the semicolon should work.

blocks|key|3255947|text|正确的字符(逗号或冒号)取决于用途。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3255948|逗号(,)将只对有问题的两个单元格求和。|offset|length|style|CODE|3255949|冒号(:)将对范围内的所有单元格求和，角点由这两个单元格定义。|3255950|entityMap^0|0|3|1|0|3|1|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

The correct character (comma or colon) depends on the purpose.

Comma (<code>,</code>) will sum only the two cells in question.

Colon (<code>:</code>) will sum all the cells within the range with corners defined by those two cells.

blocks|key|411245|text|Treb，Matthieu的问题是由在非英语语言中使用Excel引起的。在许多语言版本中，";“是正确的分隔符。即使是函数也会被翻译(SUM可以是SOMMA、SUMME或其他任何形式，这取决于您所使用的语言)。Excel通常会理解这些差异，如果由巴西人打开在法国创建的工作簿，他们通常不会有任何问题。但是VBA只会说美国英语，所以对于我们这些使用一种(或多种)外语工作的人来说，这可能是一个令人头疼的问题。你和CharlesB都给出了对美国用户来说没问题的答案，但Mikko理解了真正的问题并给出了正确的答案(这对我来说也是正确的-我是一个在意大利为一家德语公司工作的英国人)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|411246|entityMap^0|48|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Treb, Matthieu's problem was caused by using Excel in a non-English language. In many language versions ";" is the correct separator. Even functions are translated (SUM can be SOMMA, SUMME or whatever depending on what language you work in). Excel will generally understand these differences and if a French-created workbook is opened by a Brazilian they will normally not have any problem.
But VBA speaks only US English so for those of us working in one (or more) foreign langauges, this can be a headache.
You and CharlesB both gave answers that would have been OK for a US user but Mikko understod the REAL problem and gave the correct answer (which was also the correct one for me too - I'm a Brit working in Italy for a German-speaking company).

I'm trying to use VBA to write a formula into a cell in Excel.
My problem is that when I use a semicolon (<code>;</code>) in my formula, I get an error:

<blockquote>
 <code>Run-time error 1004</code>
</blockquote>

My macro is the following : 

<pre><code>Sub Jours_ouvres()
 Dim Feuille_Document As String
 Feuille_Document = "DOCUMENT" 
 Application.Worksheets(Feuille_Document).Range("F2").Formula = "=SUM(D2;E2)" 
End Sub
</code></pre>

Write a formula in an Excel Cell using VBA

我正在尝试使用VBA将公式写入Excel的单元格中。我的问题是，当我在我的公式中使用分号(;)时，我得到一个错误： Run-time error 1004我的宏如下：Sub Jours_ouvres()    Dim Feuille_Document As String    Feuille_Document = "D...

问使用VBA在Excel单元格中编写公式
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用VBA在Excel单元格中编写公式EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用VBA在Excel单元格中编写公式
EN