VBA String concatenation
Is there any Java-like solution for concatenatin strings in VBA?
I want to use a MsgBox in a way like t开发者_Python百科his:
...
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 that, my code hangs up at this point. (incompatible Types)
You should always use &
when concatenating;
MsgBox "Rows of the file: " & UT_rows
精彩评论