Martin,

I have a similar situation, but I want to merge the names in column A. Can you please assist with how I would need to alter the above code to do this?

My spread sheet is on a very large scale also and there may be up to 100 names that need to be merged at times. Do I need to change any other parts of the code to accommodate for this?

thanks

Sue.