Any way to determine width of Data Group panel

[jkm]

In excel, when you group:
rows, data grouping levels are shown in a frame to the left of row numbers
columns, data grouping levels are shown in a frame above column letters


Is there a way to determine the width/height of the frame added to excels window?

[JLGWhiz]

If you know the cell ranges for the groups the theis method will give you the width and height.

Sub t()
MsgBox Range("A2:D2").Width
MsgBox Range("A2:A10").Height
End Sub

[jkm]

Thanks, but I think you misunderstood the question.
Your routine provides height of grouped say rows.
I'm after changes made to the width of the excel window frame when rows are grouped.
That part of the frame that shows the + & - signe to expand & collapse rows.

[JLGWhiz]

Thanks, but I think you misunderstood the question.
Your routine provides height of grouped say rows.
I'm after changes made to the width of the excel window frame when rows are grouped.
That part of the frame that shows the + & - signe to expand & collapse rows.

I haven't worked with Groups that create the frames you are describing, but you can probably use this before and after and if there is a difference in the numbers, then that should be the the added frame.

Sub t()
MsgBox ActiveWindow.UsableWidth
MsgBox ActiveWindow.UsableHeight
End Sub

If that does not give you what you need, I have no other suggestions.