collapsed

Hello, I've been trolling this forum on how to expand grouped rows based on cell value in VBA but haven't been able to get any of the posted codes to work for me. I have three sections of collapsed grouped rows that I would like to have automatically expand if the cell value changes to...

Hi, I have a list of postal codes arranged on 1 column of around 13000 rows. Some of these postal codes could be collapsed and setup in ranges since they are consecutive like in the example below: 121012 and 121013 could be collapsed in 1 row as Low:121012 High:121013 <tbody> Country IATA...

In the Excel VBA editor window, is there a way to have it open with all projects collapsed by default? Every time I open the window to edit a macro, my Personal XLSB file shows fully expanded, which I don’t like because it takes up space and I have to manually collapse it to see the other...

I found this: Sub Collapse_All()mp ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 End Sub However, when expanding the groups, they are still expanded. For example, there are 5 groups expanded. They get collapsed with the above code. The 2nd group is expanded & all subgroups...

Hello; I haven't been able to find this answer yet so here goes. . . For years I've noticed if you paste a picture onto an Excel sheet or create a macro button, and you change the properties to move and size with rows, and you group the rows, and you collapse the rows, when you "un-collapse" the...