Joining A Range Of Cells Into A String

I feel like I should be be able to do something like Join(Range(XX)," ") to create a space-separated string of values...

Have I missed an easy one-liner, versus one by one concatenating the value from each cell?

In this case, I am doing exactly that - taking 4 columns of more or less unimportant data and cramming them into a single column just in case they are needed someday.


Sub Test()
Dim strTemp As String

strTemp = _
Range("C2").Value & " " & _
Range("D2").Value & " " & _
Range("E2").Value & " " & _
Range("F2").Value
'//Result: strTemp = "a b c d"

'//This fails - is it possible to do something like this
strTemp = Join(Range("C2:F2"), " ")

End Sub