Hi,

I have created a macro that adds rows with the formulas from the previous
row. This will work perfectly for people wanting to add rows within a
'section'. Now I would like to have a macro that add's a new 'section' which
is basically just a new row that is a different colour to the previous rows
and without the formulas. Can someone please help with the code to achieve
this.

More info:
The table that i have created has a blue row and then yellow rows with
details and calculations in it. There can be as many yellow rows as needed
for the detail to do with that section. To visually see a new section I have
added another blue row and then started with the yellow rows again. I have
managed to create the macro that adds the yellow rows automatically but
cannot get one that adds a blue row as it is not the same as the row before
it.

Can someone please help?

Thanks