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!!!!

Copy the row above where you want to insert rows. Select x amount of rows,
then right-click, insert copied cells.

Assuming you've setup the shading via fomulas and the formulas in the cells
use proper relative/absolute referencing, this should work very well for you.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Andrew" wrote:

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!!!!

Thanks Luke works great

"Luke M" wrote:

Copy the row above where you want to insert rows. Select x amount of rows,
then right-click, insert copied cells.

Assuming you've setup the shading via fomulas and the formulas in the cells
use proper relative/absolute referencing, this should work very well for you.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Andrew" wrote:

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!!!!