Thanks zbor. I am working on 2 computers and forgot to copy the VBA code. Works much better now It concatenates all the values....is is possible to check for duplicate values and if already part of the list, don't add it ? Thanks again.