Macro for inserting new rows below a group of rows
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