Thank you very much for responding.

I have just tried your macro and it gave me runtime error 5992, saying that I cannot access specific columns in the collection, because cells have different width. It did combine the tables, but the problem of varying column width persisted.

Would you be so kind as to suggest what might be wrong? Perhaps the macro should include formatting cell width to default?