I'm trying to transfer formula =A2&" "&B2&". "&C2
to vba, but can't find a way to add space or dot.
So far I have:
Sub Concatenate()
Range("D2:D200").Formula = "=A2&B2&C2"
Range("D2:D200").Value = Range("D2:D200").Value
End Sub
I'm trying to transfer formula =A2&" "&B2&". "&C2
to vba, but can't find a way to add space or dot.
So far I have:
Sub Concatenate()
Range("D2:D200").Formula = "=A2&B2&C2"
Range("D2:D200").Value = Range("D2:D200").Value
End Sub