I'm trying to put together VBA code that groups rows based on indent level. I have data in a table and column B contains the data that will indented. Functionally I want the code to perform the following: When the indent level is increased to 1 the row is grouped When the indent level is decreased to 0 the row is ungrouped This seems like it would be simply code, but for the life of me it has me stumped. Can anybody help?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA for Group on Indent

Thread starter Cokemachine
Start date Nov 22, 2021

Cokemachine

New Member

Nov 22, 2021

I'm trying to put together VBA code that groups rows based on indent level. I have data in a table and column B contains the data that will indented. Functionally I want the code to perform the following: