I know this has probably been covered before, but i cant find what i'm
looking for so perhaps someone can help.
Basically i want to insert multiple rows (anything from 1 to 100) but i want
the same formatting as the rows above/below. The formatting is just each
alternate row is shaded/coloured & columns 'B' to 'E' are merged. There are
also formulas that calculate values in the cells in other columns. Ideally
when inserting the formulas would also be copied/inserted relative to the
cells in adjacent rows.

I am just starting to explore vba concepts so nothing to complicated
please!!!!