如何在VBA中连接字符串? [英] How can I concatenate strings in VBA?

问题描述

此问题来自VBA中 Range.Formula =下的注释引发一个奇怪的错误.

我通过反复试验编写了该程序，因此我自然尝试使用+连接字符串.

I wrote that program by trial-and-error so I naturally tried + to concatenate strings.

但是，连接字符串时，&比+更正确吗?

But is & more correct than + for concatenating strings?

推荐答案

&始终在字符串上下文中求值 ，而如果其中一个操作数不是字符串，则+可能不会连接:

& is always evaluated in a string context, while + may not concatenate if one of the operands is no string:

"1" + "2" => "12"
"1" + 2   => 3
1 + "2"   => 3
"a" + 2   => type mismatch

这只是潜在错误的微妙来源，因此应避免使用. & 总是表示字符串连接"，即使其参数为非字符串也是如此:

This is simply a subtle source of potential bugs and therefore should be avoided. & always means "string concatenation", even if its arguments are non-strings:

"1" & "2" => "12"
"1" &  2  => "12"
 1  & "2" => "12"
 1  &  2  => "12"
"a" &  2  => "a2"

这篇关于如何在VBA中连接字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！