Yes, that exactly what I would do. Sorry I did not give an example.

Dim sTemp As String
sTemp = "" 'initialize
sTemp = sTemp & "my,values,here"
sTemp = sTemp & "continue,myvalues,fromhere"
sTemp = sTemp ...and so on

Kind regards,
Garry