How to concatenate strings in vba in Excel
What is the difference between + and & in terms of concatenation?
Answer:
from stackoverflow:com (see link here under)
& 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"