Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add

[jazz2409]

Your file has an extra sheet new table, but no indication of what you want merged, nor any new code. It stumps me that you create a new table AND then want to merge columns, why not create a single column to hold the information you want in the first place?

Sorry I forgot to indicate on that sheet what needs to be merged *facepalm*
I need to merge cell B1 and C1, D1 and E1, and F1 and G1