VBA string concatenation

Is there any Java-like solution for concatenatin strings in VBA?

I want to use MsgBox as follows:

...
Set UT = Workbooks(dropdownValue).Worksheets(1)
With UT
       UT_rows = .Cells(3, 15).End(xlDown).Row
End With
MsgBox "Rows of the file: " + UT_rows

But when I do this, my code freezes at this point. (incompatible types)

+3
source share
1 answer

When concatenation should always be used &;

MsgBox "Rows of the file: " & UT_rows
+10
source

Source: https://habr.com/ru/post/1754775/


All Articles