Hi,

Lets say i have different text values in range A1 to A10

I want to convert those values to a single string variable

eg

dim Combinedwords as string

Combinedwords = Range("A1:A10").value
Obviously that example doesnt work.

Thanks for any help you can provide.

Beat