Excel Group Status

[OzzieOwl]

I'm not sure if this is possible, but here goes anyway.
I have an Excel Spreadsheet that has data grouped, I need to be able to detect the group status, ie expanded or supressed, does anyone out there know how to pick up this in VBA. Cheers Ozzie

 

[danomaniac]

Hey Ozzie,

rows.showdetail

will return a true or false

i.e.

loop through rows and determine if group is expanded or not

Dim rownumber

For rownumber = 1 to 100 ' or whatever
If Rows(rownumber).Showdetail = True then
'insert code here for if detail is expanded
Else
'insert code here for if detail is not expanded
end if
Next


Dan

"It's more like it is now, than it ever has been."