Copy Row with formulas by inserting number of rows required

[Bflare]

Hi all,

I have a row of cells from A13 to CB13 which I want to copy directly underneath numerous times and the amount of time would be an input in cell I2. Is there some way to achieve this with VBA?

Thanks,

Tony.

[GC Excel]

Hi BFlare,
Try this :

Please Login or Register  to view this content.

[Bflare]

Hi BFlare,
Try this :

Please Login or Register  to view this content.

Thanks, that's great.

Is it possible to copy the row as above but in between another row. I have information from row 17 downwards when I copy the rows using the above VBA it over writes these????

Thanks,

Tony.

[GC Excel]

Then, try this :

Please Login or Register  to view this content.

[Bflare]

Then, try this :

Please Login or Register  to view this content.

Fantastic thanks

Also is it possible to have a range of cells auto number. For example B13 is the first line there for B13 as the number 1 in it. If I insert another 5 lines could I get B14 to auto insert number 2, B15 number 3 etc for the amount of inserted lines?

When I insert the rows it auto saves, can I disable this so that I can use the undo button????

Thanks,

Tony.

[GC Excel]

Also is it possible to have a range of cells auto number. For example B13 is the first line there for B13 as the number 1 in it. If I insert another 5 lines could I get B14 to auto insert number 2, B15 number 3 etc for the amount of inserted lines?

In B13, right the following formula :
=ROW()-12

then run the macro

When I insert the rows it auto saves, can I disable this so that I can use the undo button????

When you run the macro, it does NOT saved the file.
You can't use the undo button when you run a macro.
You need to create a "undo" macro for that.

[Bflare]

In B13, right the following formula :
=ROW()-12

then run the macro


When you run the macro, it does NOT saved the file.
You can't use the undo button when you run a macro.
You need to create a "undo" macro for that.

Fantastic thanks