That does work (except for the column lines in the header). But, it is done completely automatically. My data does not fit that model so I want to know how to do that using code? In the process of trying to figure out how to change the header text, I deleted the only entry in the "Headers" collectio...

I want to group columns and have a heading for each group. I thought I would be able to do this with band headers but I can't see any way to do it. Any ideas? Group 1 | Group 2 ------------------------------------------------------- G1C1 | G1C2 | G1C3 | G2C1 | G2C2 | G2C3 ---------------------------...