Set a variable to a dynamic named range

[BarryTSL]

At present I use for example Dept1 = " ss, ww, rr, hj " to define a variable that I use in a sort code. I need to allow the user to preset their own values and number etc so they could end up with something like " asd, ert, fgt, vv, ff, hh, yy ". Most users will not be able to alter code.
I have set up a dynamic named range (" List1 ") on one sheet using offset and count so any number of letter conbinations can be added.
How do I code my programme something like Dept1 = Range ("List1") ??

Many Thanks

[Firefly2012]

So you want to end up with a comma delimited string? Then perhaps:

Please Login or Register  to view this content.

Assumptions:

1. List1 is a single column range (not single row range)
2. List1 will contain at least 1 value

[BarryTSL]

Thank you for such a quick reply, looks like just what I needed.