ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA: Collapse Column Groupings (https://www.excelbanter.com/excel-programming/435903-vba-collapse-column-groupings.html)

CM4@FL[_2_]

VBA: Collapse Column Groupings
 
I have a spreasheet with Columns H-AB, BD-BF, and BJ-CD grouped. Therefore I
have 1 level of column grouping. What is the VBA code to collapse and expand
these groupings?

Thanks in advance


JMay

VBA: Collapse Column Groupings
 
Try recording a macro as you do it manually, then examine the code
auto-produced. This should get you a ways down the road...

"CM4@FL" wrote:

I have a spreasheet with Columns H-AB, BD-BF, and BJ-CD grouped. Therefore I
have 1 level of column grouping. What is the VBA code to collapse and expand
these groupings?

Thanks in advance



All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com