Tom,

Thanks for the help, worked like a charm, but (there is always a but) I
did not think about this at the time, the copied range will vary in
length. I tried placing variations of this
....LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row With .Range("F56:F"
& LastRow)
etc...
But could not get it to work...how would I do this at the same time? Is
there also a way to concetanate 2 columns during this process or is it
best to do before or after this has been completed.
You have helped me in the past either via personal help or your MASSIVE
amount of help to others...For me it is most greatfully appreciated!


Thanks again,

Hans