开发者

VBA String concatenation

开发者 https://www.devze.com 2023-01-07 01:46 出处:网络
Is there any Java-like solution for concatenatin strings in VBA? I want to use a MsgBox in a way like t开发者_Python百科his:

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
0

精彩评论

暂无评论...
验证码 换一张
取 消