Ungrouping an Excel

[yash.choursia]

Hi Team,

I want to ungroup an excel.

Please help.
Thanks in Advance.

[pravallikapaluri]

@yash.choursia

I want to ungroup an excel.

Hi @yash.choursia

Use Invoke VBA

Sub UngroupCells()
    ActiveSheet.Cells.Ungroup
End Sub

Hope it helps!!

[yash.choursia]

What will i write in place of ActiveSheet? I want to Ungroup “Sheet1”.

[pravallikapaluri]

@yash.choursia

Sub UngroupSheet1Cells()
    Sheets("Sheet1").Cells.Ungroup
End Sub

[Nawazish_Ahmad]

Hi @yash.choursia

Rows

Sub UngroupRowsOnSheet1()
Sheets(“Sheet1”).Rows.Ungroup
End Sub

Columns

Sub UngroupColumnsOnSheet1()
Sheets(“Sheet1”).Columns.Ungroup
End Sub

---

**Note: macros need to be enabled in your Excel file

Happy Automation