Grouping / Ungrouping columns

[nimv1]

Hi there,

I hope you can help me.
I am constantly having to ungroup a number of columns / rows in order to group again as I have to add another 1 column / row.
Is there a way of simply extending the current grouped column by adding the next column / row, or do I have to ungroup first, then regroup again!

Thanks and Regards

Nim

[Aardigspook]

Adding a column to the right or row to the left of a group should result in it being added to the group. For example, if you have cols E-K grouped, select L1 and add a column, the new col L should be added to the group.

What doesn't work is to add to the left of / above a group. For example, with the same E-K group, selecting E1 and adding a column will result in a new col D which is not in the group.
It's probably possible to fix this using VBA but that's not my area of expertise. The only way I know of to work around it is to have a blank row/column at the top/left of the group and add below/to the right of it.

Sorry I can't help more.