Login

Connect
Sign in using Facebook

Macro for inserting new rows below a group of rows

No replies
crimson's picture
crimson
Offline
Newbie
Joined: Feb 14 2012

Hi guys,
Here is my problem. I have a excel sheet with a work schedule divided into tasks. Each task has its own group of rows, which are natively collapsed. I would like to create a macro for inserting new row below the entire group without the need for expanding it and setting the active cell below which I would like to have a new row. The additional problem is that each group has different number of rows, so the macro would have to know how many rows are inside the group. Is this possible? If yes, then could someone guide me through?

Thank you in advance
Regards