B
billabong
Need to concatenate the contents of two cells together, using VBA.
for example:
Cell A1 = HSBC
Cell A2 = LN equity
so that cell A3 would show exactly as follows: HSBC LN equity
I can do this on excel spread sheet as: Cell A3 = A1&A2
(indenting contents of A2 one space) however I need to do this in VBA
format.
The beginning of my program is as follows but I get an error message
in line 2 of program.
If [C1] = "United Kingdom" Then
[A1] & [A2]
.. . . . .
ElseIf [C1] = "France" Then
.. . . . .
Else [C1] = ""
EndIf
need to do this for 15 other countries.
Your help in this would be very much appreciated.
Manuel
for example:
Cell A1 = HSBC
Cell A2 = LN equity
so that cell A3 would show exactly as follows: HSBC LN equity
I can do this on excel spread sheet as: Cell A3 = A1&A2
(indenting contents of A2 one space) however I need to do this in VBA
format.
The beginning of my program is as follows but I get an error message
in line 2 of program.
If [C1] = "United Kingdom" Then
[A1] & [A2]
.. . . . .
ElseIf [C1] = "France" Then
.. . . . .
Else [C1] = ""
EndIf
need to do this for 15 other countries.
Your help in this would be very much appreciated.
Manuel