Hi,

I need a bit of code where i can insert a new row in a spreadsheet.
The scenario is that i have a page with subtotals on it, such as Monday Total, Tuesday Total and so on.

What i need is a bit of code to insert a new row below the total row (Monday Total, Tuesday Total and so on) when the row has the words "Total" in it. So the code knows to read the word Total and then insert a new line below it.
Is an IF statement needed here?

Any help at all appreciated.

Thanks

Steve