VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
I want to use "concatenate" here...but dont understand how to use..
Code:
With Worksheets("Sheet1")
For i = 3 To RowCnt1
If .Cells(i, 3) = "" Then
Else
.Cells(i, "B").Value = WorksheetFunction.Combin(.Cells(i, 3).Value, " ", .Cells(i, 4).Value)
Next i
End With