Ungroup selected Rows with macro/vba

[mail2khalsa]

Hello,


have got data more than 1800 rows and applied 35 grouping's to it (rows count isn't same for these grouping's)


Now, I want to ungroup one (of my choice) of 35 groups & I wouldn't mind if it allows one at a time while sheet remain protected all the time...


any advise on this would be appreciated....




Thanks
mail2khalsa

 

[wigi]

Simply...

Selection.Rows.Ungroup

 

[mail2khalsa]

Hey Wigi,

It doesn't seems to be working.. can you send me a dummy excel...

Regards
mail2khalsa

Simply...

Selection.Rows.Ungroup

 

[wigi]

can you send me a dummy excel...

No. You only have to group some rows, select them again, copy/paste the code in VBA and run it. That's all I did for testing.

 

[mail2khalsa]

not working for me.. it's more of clicking on + manually than runnning a VBA and how will identify the rows that I want to ungroup with the below coding?

No. You only have to group some rows, select them again, copy/paste the code in VBA and run it. That's all I did for testing.

 

[wigi]

- Why do you say "than running a VBA" if you ask for VBA in your topic title?
- "how will identify the rows that I want to ungroup with the below coding": selected rows (look at Selection in the code). Again, you ask for it in the topic title...
- Clicking the + sign will always give the same result. If you want something different, you will need a VBA-code. For example, doing an action on the currently selected rows.