How can I concatenate strings in VBA?

by

& 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"

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. Excel Number Separation [closed]
  3. excel vba compare & copy worksheets from 2 excel files
  4. VBA Stuck after certain loop
  5. How do I use FileSystemObject in VBA?
  6. Is the . in .Range necessary when defined by .Cells?
  7. How to return a result from a VBA function
  8. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  9. Run Excel Macro from Outside Excel Using VBScript From Command Line
  10. How to put a tooltip on a user-defined function
  11. If WorkSheet(“wsName”) Exists [duplicate]
  12. How to merge rows in a column into one cell in excel?
  13. How to copy sheets to another workbook using vba?
  14. Autofilter with column formatted as date
  15. Excel vba refresh wait
  16. hiding formulas in formula bar
  17. Excel VBA: getting row of clicked button [duplicate]
  18. VBA Many buttons point to the same _Click sub
  19. Excel VBA Filter Change event handler
  20. How to copy only values in excel vba from a range?
  21. How to suppress Update Links warning?
  22. How do we use restful APIs from Excel macros (vba)?
  23. Cannot VBA write data to cells in Excel 2007/2010 within a function
  24. Handle “No cells were found” error when filtered range is empty
  25. Excel: the Incredible Shrinking and Expanding Controls [closed]
  26. How to send email to multiple recipients with addresses stored in Excel?
  27. Writing a VLOOKUP function in vba
  28. Handle cancellation of InputBox to select range
  29. VBA: How to combine two ranges on different sheets into one, to loop through
  30. How to protect Excel workbook using VBA?

Leave a Comment