If you want to merge a lot of cells in columns on a row by row bases
see MergeRxR_Join macro in
http://www.mvps.org/dmcritchie/excel/merge.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm