I am trying to set a group of four cell to three variables.

Dim sec1 As String (tried Value, Range and Variant also)
Dim sec2 As String
Dim sec3 As String

sec1 = Range("B3:E3").String (tried Value, Range and Variant also)
sec2 = Range("G3:J3").String
sec3 = Range("L3:O3").String

MsgBox sec1 & sec2 & sec3

The above produces every type miss match error available in Excel in the process.

When successful with that I then want to Randamize them something like
=Rand(sec1&" "&sec2&" "&sec3) back into three sets of four cells else where on the sheet.

Thanks,
Howard