when white space is important in VBA?

[lezawang]

Hi
the code below is working. However if I do not put white space between x and i in line 6
I would get "expect end of statement" error message. Why white space in important here? Thanks a lot.

Sub ws_name()
    Dim x As String
    Dim i As Integer
    x = InputBox("enter name")
    For i = 1 To Workbooks(2).Worksheets.Count
    Workbooks(2).Worksheets(i).Name = x & i
    Next i
End Sub

 

[DanteAmor]

Review this information:

https://docs.microsoft.com/en-us/do...ge-reference/operators/concatenation-operator

 

[Rick Rothstein]

You always need to provide a space between a variable name and the ampersand (&) following it for a line of code involving concatenation. The reason has to do with VB being backward compatible, syntax-wise, with older VB's and even the DOS versions of BASIC that preceded it. In the "old days" (and in today's VBA if you want), you could specify a variable's data type by using suffix characters attached to the end of the variable's name. The ampersand character happens to be one of those suffix characters. Placing an ampersand at the end of a variable's name makes the variable a Long data type... the others being percent sign (%) for Integer, exclamation mark (!) for Single, pound sign (#) for Double, dollar sign ($) for String and, although the data type is "newer", the at sign (@) for Currency.