VBA to delete all indents (1 Viewer)

[tmyers]

Once again I am bouncing between Access, Excel and Smartsheets and can't seem to keep anything straight in my head.

Is there a quick and dirty method to delete child/indented (I think in Excel terms, its grouped rows?) rows in excel? I seen range.indentlevel but that does not appear to be what I am after. I am dealing with a sheet that has several thousand rows, but a large chunk of them are child/collapsed rows that don't have any pertinent data and I would like to remove them if possible.

 

[Minty]

This will do what you want;

Delete Only Grouped Columns or Rows

This VBA code will loop through the columns/rows on your active worksheet and delete the columns/rows that are grouped together. You could easily modify this snippet to only format grouped columns or rows too if that is what you need.

www.thespreadsheetguru.com

 

[tmyers]

This will do what you want;

Delete Only Grouped Columns or Rows

This VBA code will loop through the columns/rows on your active worksheet and delete the columns/rows that are grouped together. You could easily modify this snippet to only format grouped columns or rows too if that is what you need.

www.thespreadsheetguru.com

I just found that myself once I remembered the correct term was group. Its so hard to keep all the terminology right from one thing to another.