I was using the + sign as I
got it in the code from the Microsoft on-line training program. I am
pasting that code below for you. Here they are trying to concancate
the last name and first name, which are kept in two columns. Please
let me where am I going wrong here.
Sub LoopRange1()
'Have x start at row 3
x = 3
'Loop until a blank row is found
Do While Cells(x, 3).Value <> ""
'This will put the value of the third and fourth columns (C
and D) together,
'with a space between, and into the fifth column (E)
Cells(x, 5).Value = Cells(x, 3).Value + " " + Cells(x,
4).Value
'increase the value of x by 1 to act on the next row
x = x + 1
Loop
End Sub