Inserting multiple rows
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!!!!
|